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
-
Sign in to the Amazon Web Services Management Console and open the Amazon DMS console at https://console.aws.amazon.com/dms/v2/
. -
Choose your Amazon Region.
-
Choose Migration projects. The Migration projects page opens.
-
Choose
dm-project
, and then choose Data migrations. -
Choose Create data migration.
-
For Name, enter a unique name for your data migration. For example, enter
postgresql-replication
. -
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, Amazon 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.
-
Select the check box for Turn on CloudWatch logs to store data migration logs in Amazon CloudWatch.
-
For IAM service role, choose the IAM role that you created in Step 1.
-
For Stop mode, choose Don’t stop CDC.
-
Choose Create data migration.
Amazon 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.