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

Amazon Web Services

Migrating from Microsoft SQL Server to Amazon DynamoDB

Amazon Web Services and Amazon via AWS Skill Builder

Overview

  • 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

Reviews

Start your review of Migrating from Microsoft SQL Server to Amazon DynamoDB

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.