Migrating from Microsoft SQL Server to Amazon DynamoDB

• Amazon DynamoDB is a cloud-native NoSQL database offering from Amazon Web Services (AWS). Its scale and performance characteristics have made DynamoDB one of the fastest growing services in AWS history. In this third course from the Breaking Free from Legacy Databases curriculum, AWS Hero Alex DeBrie demonstrates the step-by-step process of migrating a Microsoft SQL Server database to DynamoDB. 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 Microsoft SQL Server database to a cloud-native NoSQL database with Amazon DynamoDB

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 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 Database Migration Service (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