Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Microsoft

Migrate SQL workloads to Azure

Microsoft via Microsoft Learn

Overview

  • Module 1: Introduction to data platform modernization
  • 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
  • Module 2: Assess and convert SQL Server databases using the Data Migration Assistant (DMA)
  • 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
  • Module 3: Test and optimize SQL Server databases using the Database Experimentation Assistant (DEA)
  • 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
  • Module 4: Migrate SQL workloads to Azure virtual machines
  • 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
  • Module 5: Migrate SQL workloads to Azure SQL Databases
  • 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.
  • Module 6: Migrate SQL workloads to Azure Managed Instances
  • 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

Syllabus

  • Module 1: Introduction to data platform modernization
    • Introduction
    • Understand data platform modernization
    • Understand the stages of data migration
    • Explore the available data migration technologies
    • Exercise: Compare on-premises Azure costs
    • Summary
  • Module 2: Assess and convert SQL Server databases using the Data Migration Assistant (DMA)
    • 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
  • Module 3: Test and optimize SQL Server databases using the Database Experimentation Assistant (DEA)
    • 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
  • Module 4: Migrate SQL workloads to Azure virtual machines
    • Introduction
    • Considerations of SQL Server to Azure virtual machine migrations
    • SQL workloads to Azure virtual machine migration options
    • Configure and optimize your applications
    • Summary
  • Module 5: Migrate SQL workloads to Azure SQL Databases
    • 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
  • Module 6: Migrate SQL workloads to Azure Managed Instances
    • 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

Reviews

Start your review of Migrate SQL workloads to Azure

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.