Course Description
In this lesson from the Moving to Managed Databases on AWS curriculum, AWS hero Alex DeBrie demonstrates the step-by-step procedure for migrating a Microsoft SQL Server database to Amazon Relational Database Service (Amazon RDS). You can watch Alex walk through the steps of the migration process, or follow along using your own Amazon Web Services (AWS) account or the AWS free plan. By the end of this course, you should feel confident in your ability to migrate your existing repositories to Amazon RDS.

     • Course Level: Basic

     • Duration: 30 minutes

Activity
This course includes presentations and video demonstrations.

Course objectives
In this course, you will learn how to:

     • Migrating from SQL Server to Amazon RDS
target
This course is suitable for:

     • Customers, Amazon employees, and AWS partners with AWS experience, including a background in database administration and design

     • Data Platform Engineer

     • Database developers

     • Solutions Architect 

prerequisites
We recommend that participants in 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 a SQL Server database instance in Amazon RDS

     • Lesson 3. Create a replication instance in AWS Database Migration Service (AWS DMS)

     • Lesson 4. Establish source and target endpoints for database migrations

     • Lesson 5. Create a replication task in AWS DMS

     • Lesson 6. Complete the migration and clean up resources

     • Lesson 7. in conclusion