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

0

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 个月前238 查看次数
1 回答
0

Hello,

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!

AWS
已回答 3 个月前
profile picture
专家
已审核 2 个月前

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则