Migrating from Oracle to Amazon Aurora

Amazon Aurora is a cloud-native relational database offered by Amazon Web Services (AWS). Its performance characteristics, ease of use, and compatibility with existing database engines have made it the fastest growing service in AWS history. In this second course from the Breaking Free from Legacy Databases curriculum, AWS Hero Alex DeBrie demonstrates the step-by-step process of migrating an Oracle database to Aurora. You can watch Alex explain the steps of the migration process or follow along using your own AWS account.

Course level: Intermediate

Duration: 40 minutes

Activities

This course includes presentations and video demonstrations.

Course objectives

In this course, you will learn to:

• Migrate from a legacy Oracle database to a cloud-native relational database with Amazon Aurora

This course is intended for:

• Customers, Amazonians, and AWS Partners who have experience with AWS, including a background in database administration and design
• Data platform engineers
• Database developers
• Solutions architects

Prerequisites

We recommend that attendees of this course have:

• Basic understanding of databases, including maintenance and support
• Completed the AWS Planning and Designing Databases course 

Course outline

Course 2: Migrating from Oracle to Amazon Aurora

• Lesson 1. Introduction
• Lesson 2. Create an Oracle database
• Lesson 3. Load your Oracle database with sample data
• Lesson 4. Create a PostgreSQL-compatible database in Aurora
• Lesson 5. Migrate your schema with AWS Schema Conversion Tool (AWS SCT)
• Lesson 6. Create a replication instance in AWS Database Migration Service (AWS DMS)
• Lesson 7. Create endpoints in AWS DMS
• Lesson 8. Create a replication task in AWS DMS
• Lesson 9. Complete the migration and clean up resources
• Lesson 10. Conclusion