Skip to content

Contact sales

By filling out this form and clicking submit, you acknowledge our privacy policy.
  • Labs icon Lab
  • A Cloud Guru
Google Cloud Platform icon

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.

Google Cloud Platform icon

Path Info

Clock icon Intermediate
Clock icon 1h 15m
Clock icon Sep 26, 2022

Contact sales

By filling out this form and clicking submit, you acknowledge our privacy policy.

Table of Contents

  1. 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.

  2. 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.
  3. 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.

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.

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.

Start learning by doing today

View Plans