- Lab
- Cloud
- Data
Migrating an On-site PostgreSQL Database to Amazon Aurora
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.
Path Info
Table of Contents
-
Challenge
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.
-
Challenge
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
-
Challenge
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.
What's a lab?
Hands-on Labs are real environments created by industry experts to help you learn. These environments help you gain knowledge and experience, practice without compromising your system, test without risk, destroy without fear, and let you learn from your mistakes. Hands-on Labs: practice your skills before delivering in the real world.
Provided environment for hands-on practice
We will provide the credentials and environment necessary for you to practice right within your browser.
Guided walkthrough
Follow along with the author’s guided walkthrough and build something new in your provided environment!
Did you know?
On average, you retain 75% more of your learning if you get time for practice.