Oracle to Amazon Aurora (PostgreSQL)

Oracle to Amazon Aurora (PostgreSQL)

Now that you have completed setting up the workshop enviornment, you are ready to migrate a sample data base.

This step-by-step guide demonstrates how you can use AWS Database Migration Service (DMS) and AWS Schema Conversion Tool (AWS SCT) to migrate data from an Oracle database to Amazon Aurora (PostgreSQL). Additionally, you will use AWS DMS to continually replicate database changes from the source database to the target database.

The environment for this lab consists of:

  • An Amazon EC2 instance used to run the AWS Schema Conversion Tool (SCT) as well as other applications needed to complete the lab.
  • An Amazon RDS instance used to host the source Oracle database.
  • An Amazon RDS Aurora (PostgreSQL) instance used as the target database.

Diagram

Before proceeding further, make sure you have completed the instructions in the Pre-requisites section that preceeded this chapter.

Contents

  1. Schema Conversion
  2. Data Migration
  3. Summary