Migrating from Microsoft SQL Server to Amazon RDS

In this course from the Moving to Managed Databases on AWS curriculum, AWS Hero Alex DeBrie demonstrates the step-by-step process of migrating a Microsoft SQL Server database to Amazon Relational Database Service (Amazon RDS). You can either watch Alex explain the steps of the migration process or follow along using your own Amazon Web Services (AWS) account or the AWS Free Tier. At the end of this course, you should feel confident in your ability to migrate an existing database to Amazon RDS.

• Course level: Fundamental
• Duration: 30 minutes

Activities

This course includes presentations and video demonstrations.

Course objectives

In this course, you will learn to:

• Migrate from SQL Server to Amazon RDS

Intended audience

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
• AWS Planning and Designing Databases course

Course outline

• Lesson 1. Introduction
• Lesson 2. Create SQL Server database instance in Amazon RDS
• Lesson 3. Create a replication instance in AWS Database Migration Service (AWS DMS)
• Lesson 4. Create source and target endpoints for your database migration
• Lesson 5. Create a replication task in AWS DMS
• Lesson 6. Complete the migration and clean up resources
• Lesson 7. Conclusion