Converting and migrating a database to AWS

Now that we've learned the theory behind how SCT and DMS work to assess, convert, and migrate a database, let's practice our knowledge in a hands-on lab. In this lab, we are going to create an RDS Microsoft SQL Server database as our source and convert and migrate it to an RDS MySQL database.

AWS Account Costs

RDS SQL Server and DMS are chargeable by AWS and are not covered by the free tier. This lab aims to let you learn about these tools, which are major areas within the DB Specialty exam, while keeping costs as low as possible.

Setting up

Before we can start any conversion and migration, we need a source and target database. To give us a schema to work with, we will use the Microsoft SQL Server Northwinds sample data, which is available here: https://github.com/microsoft/sql-server-samples/blob/master/samples/databases/northwind-pubs/instnwnd.sql.

First, we will create an RDS SQL Server database and restore the...