How to migrate from Oracle to Amazon Aurora

Introduction

In this lesson, you migrate a legacy Oracle database to a cloud-native database with Amazon Aurora. First, you create an Oracle database and load it with sample data to help with the walkthrough. Then you create a database in Aurora and migrate the data from your Oracle database by using AWS DMS. At the end of this lesson, you should feel confident in your ability to migrate from a legacy database to a cloud-native database with Aurora.

Break Free from Legacy Databases - How to Migrate from Oracle to Amazon Aurora (31:37)

Time to complete: 3045 minutes

Why use Aurora?

Aurora is a fully managed relational database provided by AWS. It has MySQL-compatible and PostgreSQL-compatible engines but was purpose-built for the cloud for better performance. You get faster performance and better availability than with legacy database options.

With Aurora, database operations are managed by AWS, leaving your team free to focus on innovation. Aurora handles cluster scaling, instance failover, data backups, and software updates. Rely on the efficiencies of the AWS Cloud to use a faster, cheaper, and more reliable database option.

Lesson contents

In this lesson, you learn how to migrate a legacy Oracle database to a fully managed, cloud-native database using Aurora. This lesson has eight steps.

In this lesson, you migrated a legacy database to a cloud-native relational database using Aurora. When moving from a legacy database to a cloud-native database, there may be inconsistencies in the schema and code objects between the two database engines. With AWS SCT, migrating between database engines is much safer. Additionally, AWS DMS makes it easier to move your data from one database to another.