Getting started with Amazon Database Migration Service
In the following tutorial, you can find out how to perform a database migration with Amazon Database Migration Service (Amazon DMS).
To perform a database migration, take the following steps:
-
Set up your Amazon account by following the steps in Set up for Amazon Database Migration Service.
Create your sample databases and an Amazon EC2 client to populate your source database and test replication. Also, create a virtual private cloud (VPC) based on the Amazon Virtual Private Cloud (Amazon VPC) service to contain your tutorial resources. To create these resources, follow the steps in Complete prerequisites to set up Amazon Database Migration Service.
-
Populate your source database using a sample database creation script
. -
Use DMS Schema Conversion or the Amazon Schema Conversion Tool (Amazon SCT) to convert the schema from the source database to the target database. To use DMS Schema Conversion, follow the steps in Getting started with DMS Schema Conversion. To convert the schema with Amazon SCT, follow the steps in Migrate schema.
-
Create a replication instance to perform all the processes for the migration. To do this and the following tasks, take the steps in Replication.
-
Specify source and target database endpoints. For information about creating endpoints, see Creating source and target endpoints.
-
Create a task to define what tables and replication processes you want to use, and start replication. For information about creating database migration tasks, see Creating a task.
-
Verify that replication is working by running queries on the target database.
Learn more about working with Amazon Database Migration Service
Later in this guide, you can learn how to use Amazon DMS to migrate your data to and from the most widely used commercial and open-source databases.
We also recommend that you check the following resources as you prepare and perform a database migration project:
-
Amazon DMS Step-by-Step Migration Guide – This guide provides step-by-step walkthroughs that go through the process of migrating data to Amazon.
-
Amazon DMS API Reference – This reference describes all the API operations for Amazon Database Migration Service in detail.
-
Amazon CLI for Amazon DMS – This reference provides information about using the Amazon Command Line Interface (Amazon CLI) with Amazon DMS.