Questions tagged with Microsoft SQL Server
Content language: English
Select up to 5 tags to filter
Sort by most recent
Browse through the questions and answers listed below or filter and sort to narrow down your results.
I am using MS-SQL Server 2012 and 2016 on-prem. I want to capture CDC from this database and load it into Redshift using DMS. Since our tables have primary keys, MS-Replication seems to be the only...
1
answers
0
votes
1908
views
I have a customer who is planning a migration from on-prem SQL-Server to EC2 SQL Server using DMS. They want to know what will happen in the event the SQL Server AG fails over (on-prem to on-prem...
1
answers
0
votes
800
views
asked 4 years agolg...
While migrating from SQL Server or Sybase database to PostgreSQL, how do you convert a stored procedure with return status and check if procedure call is successful.
Sample example:
EXEC...
1
answers
0
votes
505
views
asked 4 years agolg...
Hi,
What is the best practice for migrating an RDS instance from SQL Server Standard Edition to SQL Enterprise Edition?
Thanks,
1
answers
0
votes
1227
views
asked 4 years agolg...
A customer is exploring RDS SQL server. The RDS SQL Server documentation (https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/SQLServer.Procedural.Importing.html) states that “Native backups of RDS...
1
answers
0
votes
374
views
For SQL Server running on EC2 and using FSx, when the FSx maintenance window happens, will there be an interruption to SQL Server ? Do the databases become disconnected?
1
answers
0
votes
534
views
asked 4 years agolg...
1. Can I stop/resume replication for a RDS SQL Server Read Replica, like we do with on-prem SQL Server?
2. is there any recommended max db size for a replication to occur smoothly?
3. is there any...
1
answers
0
votes
992
views
asked 4 years agolg...
I'm testing Linked Server on RDS SQL Server to point to existing SQL Server (non RDS). Test connection throw error with the following message :
------------------------------
ADDITIONAL...
1
answers
0
votes
1190
views
Is there a work around to scaling an RDS MS SQL Server instance type/size down (with no downtime) without building out a new RDS instance from a snapshot as that has down time?
Thank you.
1
answers
0
votes
1643
views
asked 4 years agolg...
A customer is running SQL Server Standard 2012 on an i2.xlarge instance. He wants to upgrade to i3.xlarge and SQL Server Standard 2017.
Are there any issues with SQL server and changing the instance...
1
answers
0
votes
878
views
Hello,
When I use the RDP session I only see one Command Prompt window. I don't see a Windows UI. Is this AMI bad?
Additionally, I'm trying to remotely connect to the SQL Server that is...
3
answers
0
votes
226
views
asked 5 years agolg...
A customer is in the midst of RDS adoption and they have lots of questions. Here are the latest few:
1. Our product uses some custom error messages from sys.messages. Based on our installation...
1
answers
0
votes
377
views
asked 6 years agolg...