SQL Server to Aurora --SCT. is there a way to automate the process?


I am working on SQL server to Aurora postgres migration and wondering if there is a way to automate this process? I am able to generate script after setting up source and target DB, but when I generate scripts, it doesn't contain aws specific schemas. I have multiple small databases with different schemas and was hoping if there is a way to automate /script the process, so instead of manually doing this, I can automate this?

I can generate sql server extension pack but again it is manual process.

demandé il y a 3 mois241 vues
1 réponse


AWS SCT provides a project-based user interface to automatically convert the database schema of your source database into a format compatible with your target RDS instance. Please refer to the blog below that includes information about the level of automation AWS SCT gives for each type of SQL Server database object. It will help in getting an idea of how much manual work is required for each object when converting to Aurora PostgreSQL. For example, converting SQL Server tables, views, and stored procedures has an automation rating of 4/5, which implies a higher level of automation versus manual work. In contrast, converting objects like cursors have a conversion automation rating of 3/5, which requires a bit more manual work.

[+] Migrate SQL Server to Amazon Aurora PostgreSQL using best practices and lessons learned from the field - https://aws.amazon.com/blogs/database/migrate-sql-server-to-amazon-aurora-postgresql-using-best-practices-and-lessons-learned-from-the-field/

Further, you may refer to the document below that shares information about SQL Server to PostgreSQL extension pack in AWS SCT. This extension pack emulates SQL Server database functions in the converted PostgreSQL code.

[+] Converting SQL Server to PostgreSQL - https://docs.aws.amazon.com/SchemaConversionTool/latest/userguide/CHAP_Source.SQLServer.ToPostgreSQL.html

Additionally, please refer to the documentations below which would be helpful to you as per your requirements :

Thank you!

répondu il y a 3 mois
profile picture
vérifié il y a 2 mois

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions