Microsoft SQL Server modernization workshop


In this workshop we will be migrating an existing SQL Server 2019 database over onto a serverless Amazon Aurora (MySQL) instance. In addition to the existing tools that we are familiar with (SSMS, MySQL Workbench), we will also explore some of the services that AWS has to offer, that allows seamless migrations from one database platform to another. Here are the AWS services we will be working on:

  • Database Migration Service (DMS)
  • Schema Conversion Tool (SCT)
  • Amazon Aurora (MySQL - Serverless)

By the end of this workshop, you’ll be able to:

  • Familiarize yourself with the AWS console, and navigate through the different services
  • Use existing and familiar tools to manage SQL Server and MySQL
  • Use SCT as a way to visualize your migration effort, and also as a tool to convert database objects.
  • Migrate from MSSQL to Amazon Aurora using DMS

You can reset the checked progress at anytime by clicking on the Clear History link in the left navigation menu