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

john_migrate_db_dms

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

You can use AWS DMS to migrate relational databases, data warehouses, NoSQL databases, and other types of data stores. You can use AWS DMS to migrate between on-premises instances or between combinations of cloud and on-premises setups. AWS DMS supports both homogeneous (between two databases with the same engine) and heterogeneous (between different database engines) migrations. For example, a homogeneous migration could be from an Oracle database to an Oracle database and a heterogeneous migration could be from Oracle to MySQL. When you use AWS DMS, either the source or target database must be on an AWS service. For example, you can use AWS DMS to migrate an on-premises database to AWS or to migrate from an AWS database service to an on-premises environment.

AWS DMS creates only the minimum number of objects that are required to efficiently migrate the data. However, you might need to migrate most or all of the source schema. In this scenario, if you perform a homogeneous migration, you can migrate the schema by using your engine's native tools to export and import only the schema, without any data. If your migration is heterogeneous, 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 source and target DB engine's needs, see Setting Up for AWS Database Migration Service. Then, confirm that the AWS DMS replication instance can connect to both the source and target databases. For more information about common networking scenarios, see Network Security for AWS Database Migration Service.

When you're ready to migrate your data, see Getting Started with AWS Database Migration Service.


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

Updated: 2019-01-22