Migration Ms SQL Server to  PostgresSql

I understand you were facing issues while attempting to migrate your data from a SQL Server source to PostgeSQL on RDS.

So we were able to identify the different issues and were able to resolve them successfully. I am glad that this worked for you today.

 Again as I was saying migrations differ based on the data and the datatypes involved in the source and also on the target limitations.

I am adding some helpful links below that I hope will be useful to you today. You can always use the logs and the metrics on the tasks to identify the errors and most of these can be easily fixed immediately.

 SQL Server Source on DMS : https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.SQLServer.html

PostgreSQLTarget on DMS : https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Target.PostgreSQL.html

Best practices DMS : https://aws.amazon.com/blogs/database/introducing-aws-dms-replication-engine-version-3-1-2/

https://d1.awsstatic.com/whitepapers/RDS/AWS_Database_Migration_Service_Best_Practices.pdf

AutomatingDMS tasks : https://www.terraform.io/docs/providers/aws/r/dms_replication_task.html

https://aws.amazon.com/blogs/database/automating-aws-dms-migration-tasks/

Extraction agents: https://www.dbbest.com/blog/using-data-extraction-agents-aws-sct/

Video: https://www.youtube.com/watch?v=L8g6y5LKSa4 

Some of these links are a bit old but the concept can be useful to you. We have customers who does automation when migrating larger environments to ease the creation and management of tasks. I definitely hope that this will be useful to you today.

Migration from SQL Server to PostgreSQL specifically which will be helpful for your task. https://d1.awsstatic.com/asset-repository/products/AWS%20Database%20Migration%20Service/SQL%20Server%20to%20Aurora%20PostgreSQL%20Migration%20Playbook%201.0%20Preliminary.pdf