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

Question

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.

Answer

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 : 
- Using a Microsoft SQL Server database as a source for AWS DMS - https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.SQLServer.html 
- Using a PostgreSQL database as a target for AWS Database Migration Service - https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Target.PostgreSQL.html
- Best Practices for Migrating from SQL Server to Amazon Aurora - https://pages.awscloud.com/rs/112-TZM-766/images/DMWQ1D2S3T1_Best%20Practices%20for%20Migrating%20from%20SQL%20Server%20to%20Amazon%20Aurora%20Part%201%20and%202.pdf

Thank you!

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

相關內容