- Lab
-
Libraries: If you want this lab, consider one of these libraries.
- 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.
Lab 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.
Real skill practice before real-world application
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.
Learn by doing
Engage hands-on with the tools and technologies you’re learning. You pick the skill, we provide the credentials and environment.
Follow your guide
All labs have detailed instructions and objectives, guiding you through the learning process and ensuring you understand every step.
Turn time into mastery
On average, you retain 75% more of your learning if you take time to practice. Hands-on labs set you up for success to make those skills stick.