You can use homogeneous data migrations in AWS DMS to migrate data between two databases of the same type. Use the following workflow to create and run a data migration.
-
Create the required AWS Identity and Access Management (IAM) policy and role. For more information, see Creating IAM resources.
-
Configure your source and target databases and create database users with the minimum permissions required for homogeneous data migrations in AWS DMS. For more information, see Creating source data providers and Creating target data providers.
-
Store your source and target database credentials in AWS Secrets Manager. For more information, see Step 1: Create the secret in the AWS Secrets Manager User Guide.
-
Create a subnet group, an instance profile, and data providers in the AWS DMS console. For more information, see Creating a subnet group, Creating instance profiles, and Creating data providers.
-
Create a migration project by using the resources that you created in the previous step. For more information, see Creating migration projects.
-
Create, configure, and start a data migration. For more information, see Creating a data migration.
-
After you complete the full load or ongoing replication, you can cut over to start using your new target database.
-
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 AWS Secrets Manager.
For more information about homogeneous data migrations in AWS DMS, read the step-by-step migration walkthough for PostgreSQL to Amazon RDS for PostgreSQL migrations.
The following video introduces the homogeneous data migrations user interface and helps you get familiar with this feature.
