Part 2: Data Migration

Please note that you need to complete the steps described in Schema Conversion section as a pre-requisite for this part.

This section will demonstrate how you can use the AWS Database Migration Service to migrate data from the source Microsoft SQL Server running on an Amazon EC2 instance to the target Amazon Aurora (PostgreSQL). Additionally, you will use AWS DMS to continually replicate database changes from the source database to the target database.

AWS DMS doesn’t migrate your secondary indexes, sequences, default values, stored procedures, triggers, synonyms, views, and other schema objects that aren’t specifically related to data migration. To migrate these objects to your Aurora PostgreSQL target, we used the AWS Schema Conversion Tool in the previous section.


In this exercise you perform the following tasks: