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

preguntada hace 2 años502 visualizaciones
1 Respuesta
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
respondido hace 2 años

No has iniciado sesión. Iniciar sesión para publicar una respuesta.

Una buena respuesta responde claramente a la pregunta, proporciona comentarios constructivos y fomenta el crecimiento profesional en la persona que hace la pregunta.

Pautas para responder preguntas