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.

已提問 3 個月前檢視次數 235 次
1 個回答


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!

已回答 3 個月前
profile picture
已審閱 2 個月前

您尚未登入。 登入 去張貼答案。