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

Microsoft

Migrate SQL Server workloads to Azure SQL

Microsoft via Microsoft Learn

Overview

Prepare for a new career with $100 off Coursera Plus
Gear up for jobs in high-demand fields: data analytics, digital marketing, and more.
  • 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 Server workloads to Azure SQL

Never Stop Learning.

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

Someone learning on their laptop while sitting on the floor.