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달 전230회 조회
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달 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠