Lab
A Cloud Guru

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.

Try for free Contact sales

Path Info

Level

Intermediate

Duration

1h 15m

Published

Sep 26, 2022

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_user to the qa database on the PostgreSQL instance running on the lab bastion host.
- Target endpoint will connect as the postgres user to the postgres database on the Amazon Aurora cluster.
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.

Author

A Cloud Guru

The Cloud Content team comprises subject matter experts hyper focused on services offered by the leading cloud vendors (AWS, GCP, and Azure), as well as cloud-related technologies such as Linux and DevOps. The team is thrilled to share their knowledge to help you build modern tech solutions from the ground up, secure and optimize your environments, and so much more!

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.