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

• Introduction
• Understand data platform modernization
• Understand the stages of data migration
• Explore the available data migration technologies
• Exercise: Compare on-premises Azure costs
• Summary

• Introduction
• Decide if the Data Migration Assistant (DMA) is right for your task
• Install the DMA
• Identify compatibility issues
• Upgrade a database
• Create Azure SQL virtual machine
• Exercise: Install the Data Migration Assistant (DMA)
• Exercise: Identify compatibility issues
• Exercise: Upgrade a database
• Summary

• Introduction
• Decide if DEA is right for your task
• Install DEA
• Configure a new capture
• Review a trace analysis report
• Exercise - Install the Database Experimentation Assistant
• Exercise - Configure a new capture with DEA
• Exercise - Review a trace analysis report in DEA
• Summary

• Introduction
• Considerations of SQL Server to Azure virtual machine migrations
• SQL workloads to Azure virtual machine migration options
• Configure and optimize your applications
• Summary

• Introduction
• Choose the right SQL Server Instance option in Azure
• Migrate SQL Server to Azure SQL Database offline
• Migrate SQL Server to Azure SQL Database online
• Load and move data to Azure SQL Database
• Summary

• Introduction
• Evaluate migration scenarios to SQL Database Managed Instance
• Migrate to SQL Database Managed Instance
• Load and Move data to SQL Database Managed Instance
• Summary