CLOUD LABS
Migrate Data from Partitioned Tables in PostgreSQL Using AWS DMS
In this Cloud Lab, you’ll learn how to migrate partitioned tables in PostgreSQL to another database, Amazon Redshift, using AWS Database Migration Service (DMS).
beginner
Certificate of Completion
Learning Objectives
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:
Before you start...
Try these optional labs before starting this lab.
Relevant Courses
Use the following content to review prerequisites or explore specific concepts in detail.
Trusted by 1.4 million developers working at companies including
Your method is simple, straight to the point and I can practice with it everywhere, even from my phone, that's something I have never had in other learning platforms.
I highly recommend Educative. The courses are well organized and easy to understand.
I prefer Educative courses because they have a nice mix of text & images. I find that with full video courses, it can often be too easy to go into passive learning mode.
I prefer Educative courses because they have a nice mix of text & images. I find that with full video courses, it can often be too easy to go into passive learning mode.
Your method is simple, straight to the point and I can practice with it everywhere, even from my phone, that's something I have never had in other learning platforms.
I highly recommend Educative. The courses are well organized and easy to understand.
I prefer Educative courses because they have a nice mix of text & images. I find that with full video courses, it can often be too easy to go into passive learning mode.
Get access to Educative Cloud Labs