Exercise 01 - SQL database migration
Lab Scenario
Tailspin Toys need to migrate their on-premises SQL Server database to Azure SQL Managed Instance. This is part of the migration strategy defined to migrate Tailspin Toys workloads to Azure.
In this exercise, you will go through the steps necessary to migrate Tailspin Toys’ on-premises SQL Server database to Azure SQL Managed Instance.
Note: Since Azure SQL Manage Instance can take up to 4 hours to provision, the ARM Template deployment in the Before the Hands-on Lab deployment has already created the Azure SQL Managed Instance resource for this lab.
Objectives
After you complete this lab, you will be able to:
- Install Data Migration Assistant & Azure Data Studio
- Assess on-premises database compatibility
- Backup on-premises SQL database
- Migrate database to Azure SQL MI
Lab Duration
- Estimated Time: 75 minutes