Migrating SQL server Database to the AWS cloud.

Question

Good Morning,
I am planning to Migrate SQL Server Databases to AWS.
I would like to know if anyone can share any kind of documentation for Migration SQL Server Db to AWS.
Does Amazon RDS would be fit for SQL Server or I can look for another option to migrate?
Thank you

Answer 1

Hi, @Jinal Contractor

Yes, you can use.
AWS Database Migration Service supports SQL Server on IaaS or Azure SQL Database as PaaS as a migration source.

https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.SQLServer.html
https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.AzureSQL.html

However, please understand that downtime will occur as it does not support CDC mode.

Amazon RDS will also support the SQL Server engine, allowing you to run your existing SQL Server workloads with managed capabilities.

In addition, Amazon RDS provides an engine mode called SQL Server Custom, and it is of course possible to host SQL Server on EC2.

Answer 2

Hi @Jinal Contractor ,

Yes, it can be achieved.

Please check out this guide, it provides a variety of ways, like a simple native backup and restore, AWS DMS and so on.

Migrating Microsoft SQL Server databases to the AWS Cloud

This article provides a solution for migrating SQL Server to Amazon RDS for SQL Server using the SLQ server backup and restore method in conjunction with AWS DMS:
Migrating your SQL Server database to Amazon RDS for SQL Server using AWS DMS

But to use this way, you need to have no limitations on using SQL Server as a source for AWS DMS:
https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.SQLServer.html#CHAP_Source.SQLServer.Limitations

-------------

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.