Migrate SQL Server workloads to Azure SQL

By the end of this module, you'll be able to:

• Explain what data platform modernization is
• Review the stages of a data migration
• Recommend when to use an Azure data platform technology
• Explore the cost savings of moving your SQL workloads to Azure

In this module, you will:

• Decide if the DMA is the best tool to use for a given administration task
• Install the DMA on your client machine
• Identify compatibility issues prior to upgrade
• Upgrade a database using the DMA

In this module, you will:

• Decide if DEA is the right tool for your workload testing
• Install DEA on your client machine
• Test a typical workload on an upgraded database
• Review the results of a trace analysis report

By the end of this module, you'll be able to:

• Choose the right options when you run your SQL workloads on Azure Virtual Machines
• Explore migration options when moving SQL Server workload to an Azure Virtual Machine
• Configure and optimize your applications

By the end of this module, you'll be able to:

• Describe the considerations for a SQL Server to Azure SQL Database migration.
• Describe the methods and steps to perform an offline migration to Azure SQL Database.
• Describe the methods and steps to perform an online migration to Azure SQL Database.
• Explore the post migration steps required to ensure service continuity of your database in backup, high availability, disaster recovery, and scalability.

By the end of this module, you'll be able to:

• Evaluate migration scenarios to Azure SQL Database Managed Instance
• Migrate to Azure SQL Database Managed Instance
• Load and move data to Azure SQL Database Managed Instance