Break Free of Legacy Databases

In this three-course curriculum, you will learn about the value and process of moving from legacy databases into cloud-native databases. In the first course, you will learn why you would want to break free from legacy databases and the key factors to consider in choosing a cloud-native database. Then in the next two courses, you can either follow along, or view walk-through tutorial examples of moving to a cloud-native relational database, such as Amazon Aurora, or a cloud-native NoSQL database, such as Amazon DynamoDB.

• Course level: Intermediate
• Duration: 1 hour and 45 minutes

Activities

• This curriculum includes courses with presentations and video demonstrations.

Curriculum objectives

In this curriculum, you will learn to:

• Explain the value of using cloud-native databases to meet specific application needs
• Explain the value of moving from a legacy database into a cloud-native database solution
• Identify the factors you need to consider when moving to a cloud-native database
• Migrate from a legacy Oracle database to a cloud-native relational database with Amazon Aurora
• Migrate from a legacy Microsoft SQL Server database to a cloud-native NoSQL database with Amazon DynamoDB

This curriculum is intended for:

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

Prerequisites

We recommend that attendees of this curriculum have:

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

Curriculum outline

Course 1: Breaking Free from Legacy Databases

• Lesson 1. Introduction
• Lesson 2. Why break free from legacy databases?
  • Save money on licenses and operating expenses
  • Better performance with cloud-native design
  • Faster development speed
• Lesson 3. Factors to consider in choosing a cloud-native database
  • Choose a cloud-native database type
  • Choose a migration process
• Lesson 4. Next steps
  • Complete one or more of the hands-on migration courses within this curriculum based on your database situation

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

Course 3: Migrating from Microsoft SQL Server to Amazon DynamoDB

• Lesson 1. Introduction
• Lesson 2. Create a SQL Server database
• Lesson 3. Load your SQL Server database with sample data
• Lesson 4. Create a DynamoDB table
• Lesson 5. Create a replication instance in AWS DMS
• Lesson 6. Create endpoints in AWS DMS
• Lesson 7. Create a replication task in AWS DMS
• Lesson 8. Complete the migration and clean up resources
• Lesson 9. Conclusion