AWS DMS Service and Limitation

0

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

posta 2 anni fa503 visualizzazioni
1 Risposta
0

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.

https://docs.microsoft.com/en-us/sql/sql-server/end-of-support/sql-server-end-of-support-overview?view=sql-server-ver16#:~:text=across%20multiple%20regions.-,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

AWS
con risposta 2 anni fa

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Linee guida per rispondere alle domande