Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Amazon Web Services

Migrating from Oracle to Amazon Aurora

Amazon Web Services and Amazon via AWS Skill Builder

Overview

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

Reviews

Start your review of Migrating from Oracle to Amazon Aurora

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.