- Más nuevo
- Más votos
- Más comentarios
Hi, you have a comprehensive guide for such a migration here: https://docs.aws.amazon.com/SchemaConversionTool/latest/userguide/CHAP_Source.SQLServer.ToPostgreSQL.html
But, my personal experience (I work in migration domain) is "migrating is testing": for mission-critical workloads, you need very thorough tests to ensure functional equivalence.
So, before proposing such a migration, think about you testing plan to make sure that this migration does not alter your business results. I would suggest you to read this article to inventory all areas to deal with in preparing such a journey: https://www.enterprisedb.com/blog/microsoft-sql-server-mssql-vs-postgresql-comparison-details-what-differences
On your other question, AWS SCT is the tool to convert your db schema from SQL Server to Postgresql: https://aws.amazon.com/dms/schema-conversion-tool/
Contenido relevante
- OFICIAL DE AWSActualizada hace 2 años
- OFICIAL DE AWSActualizada hace 2 años
- OFICIAL DE AWSActualizada hace 2 años
- OFICIAL DE AWSActualizada hace 7 meses