By using AWS re:Post, you agree to the AWS re:Post Terms of Use

How do I use AWS DMS to migrate my data from one DB engine to another?

2 minute read
0

I want to use AWS Database Migration Service (AWS DMS) to migrate my data from one DB engine to another.

Short description

Use AWS DMS to migrate relational databases, data warehouses, NoSQL databases, and other types of data stores. AWS DMS supports both homogeneous (between two databases with the same engine) and heterogeneous (between different database engines) migrations. For example, a homogeneous migration is from an Oracle database to an Oracle database, and a heterogeneous migration is 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 to AWS from an on-premises database, or from an AWS database service to an on-premises environment.

Resolution

AWS DMS creates only the minimum number of objects that are required to efficiently migrate the data. However, you can migrate most or all the source schema. If you perform a homogeneous migration, then you can migrate the schema with your engine's native tools to export and import only the schema. If your migration is heterogeneous, then you can use the AWS Schema Conversion Tool (AWS SCT) to generate a complete target schema. For more information, see Getting started with AWS SCT.

If AWS DMS meets your source and target DB engine's needs, then follow the steps in 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 Security in AWS Database Migration Service.

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

Related information

Troubleshooting migration tasks in AWS Database Migration Service

Database migration step-by-step walkthroughs

Migration strategy for relational databases

AWS OFFICIAL
AWS OFFICIALUpdated 2 years ago