Modernizing Commercial Databases

Welcome

AWS DMS Schema Conversion Resources

• Lets talk about data show live demo on migrations using DMS SC - https://community.aws/content/2pA2N9sPjZUVn8fyivWgxXexh8l/accelerating-your-database-migrations-using-gen-ai-lets-talk-about-data
• DMS SCT Gen/AI Announcement - https://aws.amazon.com/about-aws/whats-new/2024/12/aws-dms-schema-conversion-generative-ai/
• ReInvent Demo with Product Team - https://www.youtube.com/watch?v=ElzTxmS6XYE

AWS Database Migration Service (DMS) Resources

• Migrate data from an on-premises Oracle database to Aurora PostgreSQL - https://docs.aws.amazon.com/prescriptive-guidance/latest/patterns/migrate-data-from-an-on-premises-oracle-database-to-aurora-postgresql.html
• Oracle Database 19c to Amazon Aurora PostgreSQL Migration Playbook - https://docs.aws.amazon.com/dms/latest/oracle-to-aurora-postgresql-migration-playbook/chap-oracle-aurora-pg.html
• Microsoft SQL Server 2019 to Amazon Aurora PostgreSQL Migration Playbook - https://docs.aws.amazon.com/dms/latest/sql-server-to-aurora-postgresql-migration-playbook/chap-sql-server-aurora-pg.html
• Migrate a Microsoft SQL Server database to Aurora MySQL by using AWS DMS and AWS SCT - https://docs.aws.amazon.com/prescriptive-guidance/latest/patterns/migrate-a-microsoft-sql-server-database-to-aurora-mysql-by-using-aws-dms-and-aws-sct.html

Q Developer Migration Resources

• AWS Q developer Guide - https://docs.aws.amazon.com/dms/latest/userguide/schema-conversion-embedded-sql.html
• Converting embedded SQL in Java applications - https://docs.aws.amazon.com/amazonq/latest/qdeveloper-ug/transform-sql.html
• Transforming code in the IDE - https://docs.aws.amazon.com/amazonq/latest/qdeveloper-ug/transform-in-IDE.html

Direction Business Case Resources

• AWS guidance document - https://docs.aws.amazon.com/prescriptive-guidance/latest/application-portfolio-assessment-guide/directional-business-case.html

Demo Team Contacts