DMS to migrate SQL Server from RDS to EC2

0

Hi.

I am working on a project to migrate our SQL Server databases from the existing environments to AWS EC2's.

My first stage was to migrate a series of SQL Server databases from it's existing RDS instance to the newly create EC2 instance with SQL Server installed. I was told the best way to migrate these databases was to use Database Migration Services and migrate them over as this would give me a repeatable process that can be started at any time.

Have I been told correctly? or is there an alternative way that's better?
Excuse my newbie way of detailing everything. I am a newbie and been thrown in at the deep end.

Thank you (In Advance)

asked 4 years ago1248 views
1 Answer
0

Hi,

yes, it is the right tool.
More information about you want to achieve here: https://aws.amazon.com/premiumsupport/knowledge-center/dms-migrate-rds-sqlserver/.

You are able to use MSSQL on RDS as source on DMS: https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.SQLServer.html

And you are able to use a MSSQL on EC2 instance as target on DMS: https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Target.html

Just check that your MSSQL version is supported.

BR,
R.

Reds
answered 4 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions