In this lab, students are asked to migrate an on-site PostgreSQL instance to Amazon Aurora using the Database Migration Service (DMS). After completing this lab, students will have hands-on experience migrating data using DMS.
Learning Objectives
Successfully complete this lab by achieving the following learning objectives:
- Create Replication Instance
Create a new DMS replication instance of instance class db.t3.medium. Be sure to select the Lab VPC and create a Single AZ instance. The instance will not need to be publicly accessible.
- Create Endpoints
Create the target and source endpoints.
- Source endpoint will connect as the
dms_userto theqadatabase on the PostgreSQL instance running on the lab bastion host. - Target endpoint will connect as the
postgresuser to thepostgresdatabase on the Amazon Aurora cluster.
- Source endpoint will connect as the
- Create Task
Create a new task and select the source and target endpoints. This migration will copy any existing data from all tables and schemas on the source database to the target and replicate ongoing changes.
