Migrating SQL to AWS

My colleagues, Julius Sacramento and Garry Singh, have developed some great hands-on labs on migrating Microsoft SQL Server to AWS.

  • Lab 1: Microsoft SQL Always On Workshop. In this workshop, you will be configuring and deploying a 2-node SQL Server 2019 cluster. Once the cluster has been created, we will be creating an AlwaysON availability group using a sample database backup. For the lab, go here.

  • Lab 2: Migrating SQL server to Amazon RDS SQL. AWS provides a managed SQL server as a service offering called Amazon Relational Database Service (RDS) for SQL Server. In this lab, you will get hands-on experience migrating a SQL database to Amazon RDS for SQL server. For the lab, go here.

  • Lab 3: Migrating SQL server to Amazon Aurora using Database Migration Service (DMS) and Schema Conversion Tool (SCT). This lab walks you through using two AWS tools: Database Migration Service (DMS) and Schema Conversion Tool (SCT) to migrate your Microsoft SQL databases to AWS. These tools can be used to migrate SQL server databases to Microsoft SQL in AWS. They also can be used to migrate to an open source database platform (e.g. MySQL or AWS’s implementation called Amazon Aurora). For the lab, go here.

  • Lab 4: Deploying SQ Server Always On with AWS Launch Wizard. In this lab, you will use AWS Launch Wizard to deploy SQL Server Always On. AWS Launch Wizard makes it easy for you to deploy Microsoft SQL Server. You input your requirements (e.g. performance, number of nodes, and connectivity) into the AWS Launch Wizard console. AWS Launch Wizard then creates the CloudFormation stack to create the infrastructure. For the lab instructions, please go here.