Overview of the homogeneous data migration process in Amazon DMS - Amazon Database Migration Service
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).

Overview of the homogeneous data migration process in Amazon DMS

You can use homogeneous data migrations in Amazon DMS to migrate data between two databases of the same type. Use the following workflow to create and run a data migration.

  1. Create the required Amazon Identity and Access Management (IAM) policy and role. For more information, see Creating IAM resources.

  2. Configure your source and target databases and create database users with the minimum permissions required for homogeneous data migrations in Amazon DMS. For more information, see Creating source data providers and Creating target data providers.

  3. Store your source and target database credentials in Amazon Secrets Manager. For more information, see Step 1: Create the secret in the Amazon Secrets Manager User Guide.

  4. Create a subnet group, an instance profile, and data providers in the Amazon DMS console. For more information, see Creating a subnet group, Creating instance profiles, and Creating data providers.

  5. Create a migration project by using the resources that you created in the previous step. For more information, see Creating migration projects.

  6. Create, configure, and start a data migration. For more information, see Creating a data migration.

  7. After you complete the full load or ongoing replication, you can cut over to start using your new target database.

  8. Clean up your resources. Amazon terminates your data migration in your migration project in three days after you complete the migration. However, you need to manually delete such resources as instance profile, data providers, IAM policy and role, and secrets in Amazon Secrets Manager.

For more information about homogeneous data migrations in Amazon DMS, read the step-by-step migration walkthough for PostgreSQL to Amazon RDS for PostgreSQL migrations.