Migrate a self-managed Microsoft SQL Server database to a fully managed database on Amazon RDS

Introduction

In this lesson, you migrate a self-managed Microsoft SQL Server database instance to a fully managed database on Amazon Relational Database Service (Amazon RDS). First, you learn why you would want to use Amazon RDS to manage your relational database. Next, you work through the steps to migrate an existing SQL Server database to Amazon RDS. At the end of this lesson, you should feel confident in your ability to migrate an existing database to Amazon RDS.

Time to complete: 3045 minutes

Move to Managed Databases - Migrate from SQL Server to Amazon RDS (18:53)
Why use Amazon RDS?

Amazon RDS is a fully managed service for running relational databases on Amazon Web Services (AWS). It has support for six different database engines, including commercial options such as SQL Server and Oracle.

With Amazon RDS, your database operations are managed by AWS, leaving your team free to focus on innovation. Amazon RDS handles instance failover, data backups, and software updates, so you can enjoy the efficiencies of the AWS Cloud for a fast and reliable database option.

Lesson contents

In this lesson, you learn how to migrate a self-managed SQL Server database to a fully managed database on Amazon RDS. This lesson has five steps.

In this lesson, you migrated an existing SQL Server database to a fully managed SQL Server database in Amazon RDS by using AWS DMS. By using Amazon RDS, you can free your developers to focus on innovation that's core to your business. By using AWS DMS, you can automate the delicate task of migrating data to a new database.