AWS Database Migration Service (DMS) facilitates data migration from different database sources to several targets within the AWS ecosystem. You can even use AWS DMS to migrate data from your on-premises database to the AWS cloud.
In this Cloud Lab, you’ll create partitioned tables in the source database, PostgreSQL, and migrate the data of these partitioned tables into a single table in Amazon Redshift. The migration will take place through AWS DMS. You’ll create an AWS DMS replication instance, source and target endpoints, and then configure a replication task. You’ll also see how change data capture (CDC) works in AWS DMS and understand its importance in scenarios where timely, accurate, and efficient handling of changes to data is necessary.
After completing this Cloud Lab, you’ll have enough knowledge and understanding to start working with AWS DMS and create replication tasks for your database migrations. Here’s the high-level architecture diagram of the infrastructure that you will create in this Cloud Lab: