Migrating Oracle databases to Amazon Aurora MySQL with DMS Schema Conversion - Database Migration Guide
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Migrating Oracle databases to Amazon Aurora MySQL with DMS Schema Conversion

This walkthrough gets you started with heterogeneous database migration from Oracle to Amazon Aurora MySQL-Compatible Edition. To automate the migration, we use the Amazon DMS Schema Conversion. This service helps assess the complexity of your migration and converts source Oracle database schemas and code objects to a format compatible with MySQL. Then, you apply the converted code to your target database. This introductory exercise shows how you can use DMS Schema Conversion for this migration.

At a high level, this migration includes the following steps:

  • Use the Amazon Web Services Management Console to do the following:

    • Create a VPC in the Amazon VPC console.

    • Create IAM roles in the IAM console.

    • Create an Amazon S3 bucket in the Amazon S3 console.

    • Create your target Aurora MySQL database in the Amazon RDS console.

    • Store database credentials in Amazon Secrets Manager.

  • Use the Amazon DMS console to do the following:

    • Create an instance profile for your migration project.

    • Create data providers for your source and target databases.

    • Create a migration project.

  • Use DMS Schema Conversion to do the following:

    • Assess the migration complexity and review the migration action items.

    • Convert your source database.

    • Apply the converted code to your target database.

This walkthrough takes approximately three hours to complete. Make sure that you delete resources at the end of this walkthrough to avoid additional charges.

Topics