AWS DMS Service and Limitation


We are planning to migrate onpremises sql servers to AWS RDS SQl Servers. Currently on premises contains multiple MSSQL server versions/engines, those want to migrate. e.g MSSQL 2015, in this case should we migrate 2015 to 2016 or 2019 or lower to 2014, what will be good.

And for this migration can we use DMS service, do we have any limitation to migrate 4 TB data.. is DMS able to manage, how to calculate required time

asked 2 years ago480 views
1 Answer

I would suggest migrating MSSQL on prem server to RDS with latest versions as long as you dont have any app compatibility issues. this way you are not on eol or approaching eol versions.,Lifecycle%20dates,-The%20following%20table

DMS doesnt have limitation on migrating based on onprem db size. Please note required timing for data migration is combination of network/source db size/table lob distribution thus i would suggest start testing in nonprod environment and that give numbers to analyse

answered 2 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