Migrating SQL databases to Azure

Workshop

In this workshop, you learn how to develop a plan for migrating on-premises VMs and SQL Server databases into a combination of IaaS and PaaS services in Azure. You perform assessments to reveal any feature parity and compatibility issues between the customer’s SQL Server 2008 R2 databases and Azure’s managed database offerings. You then design a solution for migrating their existing on-premises services, including VMs and databases, into Azure, with minimal down-time. Finally, you demonstrate some of the advanced SQL features available in Azure to improve security and performance in the customer’s applications. At the end of this workshop, you will be better able to design and implement a cloud migration solution for business-critical applications and databases.

Whiteboard Design Session

In this whiteboard design session, you work in a group to develop a plan for migrating on-premises VMs and SQL Server databases into a combination of IaaS and PaaS services in Azure. You provide guidance on performing assessments to reveal any feature parity and compatibility issues between the customer’s SQL Server 2008 R2 databases and Azure’s managed database offerings. You then design a solution for migrating their on-premises services, including VMs and databases, into Azure, with minimal down-time. Finally, you provide guidance on enabling some of the advanced SQL features available in Azure to improve security and performance in the customer’s applications.

At the end of this whiteboard design session, you will be better able to design a cloud migration solution for business-critical applications and databases.

Hands-on Lab

In this hands-on lab, you implement a proof-of-concept (PoC) for migrating an on-premises SQL Server 2008 R2 database into Azure SQL Managed Instance (SQL MI). You perform assessments to reveal any feature parity and compatibility issues between the on-premises SQL Server 2008 R2 database and Azure’s managed database offerings. You then migrate the customer’s on-premises gamer information web application and database into Azure, with minimal down-time. Finally, you enable some of the advanced SQL features in SQL MI to improve security and performance in the customer’s application.

At the end of this hands-on lab, you will be better able to implement a cloud migration solution for business-critical applications and databases.