Step 8: Configure a Data Migration - Database Migration Guide

Step 8: Configure a Data Migration

After you create the migration project with two PostgreSQL data providers, you can use this project for homogeneous data migrations.

To create a data migration

  1. Sign in to the AWS Management Console and open the AWS DMS console at https://console.aws.amazon.com/dms/v2/.

  2. Choose your AWS Region.

  3. Choose Migration projects. The Migration projects page opens.

  4. Choose dm-project, and then choose Data migrations.

  5. Choose Create data migration.

  6. For Name, enter a unique name for your data migration. For example, enter postgresql-replication.

  7. For Replication type, choose Full load and change data capture (CDC) to migrate your existing source data and replicate ongoing changes. For this replication type, AWS DMS deletes all data, tables, and other database objects on your target database. Make sure you create a backup of your target database before you start your data migration.

  8. Select the check box for Turn on CloudWatch logs to store data migration logs in Amazon CloudWatch.

  9. For IAM service role, choose the IAM role that you created in Step 1.

  10. For Stop mode, choose Don’t stop CDC.

  11. Choose Create data migration.

AWS DMS creates your data migration and sets its status to Ready. To migrate your data, you must start the data migration manually. For more information, see Step 9.