John shows you how to
migrate an Oracle database
to MySQL using DMS

john_migrate_db_dms

How do I migrate my data from one DB engine to another using AWS Database Migration Service (DMS)?

AWS DMS can migrate your data to and from many widely used commercial and open-source databases, such as Oracle, PostgreSQL, Microsoft SQL Server, Amazon Redshift, Amazon Aurora, MariaDB, and MySQL. The service supports homogeneous migrations (for example, migrating an on-premises Oracle database to an Oracle database running on an RDS DB instance), and also heterogeneous migrations between different database platforms, such as Oracle to MySQL or MySQL to Amazon Aurora. The source or target database must be on an AWS service.

AWS DMS only creates the minimal number of objects that are required to efficiently migrate the data. In most cases, when performing a migration, you will also want to migrate most or all of the source schema. If you are performing a homogeneous migration (between two databases of the same engine type), you can migrate the schema by using your engine’s native tools to export and import the schema itself, without any data. If your migration is heterogeneous (between two databases that use different engine types), you can use the AWS Schema Conversion Tool to generate a complete target schema. For more information, see Getting Started with the AWS Schema Conversion Tool.

If AWS DMS meets your needs, make sure that you and your database meet the AWS DMS requirements.

Next, ensure the AWS DMS replication instance can connect to both the source and target databases. Common networking scenarios can be found at Setting Up a Network for Database Migration.

When you're ready, you can migrate your data by following the instructions at Getting Started.


Did this page help you? Yes | No

Back to the AWS Support Knowledge Center

Need help? Visit the AWS Support Center

Published: 2017-02-09