Cloud Private

Migrate SQL Server workload to Azure SQL (DP-3001)

1 day
AzureMicrosoft SQL Server

Prepare to migrate SQL Server workloads to Azure SQL by assessing compatibility, selecting migration tools, configuring resources, and monitoring results.

Talk to a Learning ConsultantRequest a Private Class

Register or Request Training

  • Private class for your team
  • Live expert instructor
  • Online or on‑location
  • Customizable agenda
  • Proposal responses same day as request
Request Proposal

Course Overview

Prepare to migrate SQL Server workloads to Azure SQL. Learn to assess SQL Server components and compatibility, provision and configure Azure SQL resources, and select migration approaches based on business and downtime requirements.

You will work with migration tools and methods for Azure Virtual Machines, Azure SQL Database, and Azure SQL Managed Instance. The course also covers migration monitoring and post-migration responsibilities, including security, disaster recovery, compliance, and performance monitoring.

Course Benefits

  • Plan a SQL Server migration and explain the benefits of data platform modernization.
  • Assess SQL Server databases for Azure compatibility using available assessment and migration tools.
  • Provision and configure Azure SQL resources across IaaS and PaaS deployment options.
  • Select migration strategies that address workload, downtime, performance, and business requirements.
  • Migrate SQL Server databases to Azure Virtual Machines, Azure SQL Database, and Azure SQL Managed Instance.
  • Monitor migration progress and manage migration state.
  • Complete post-migration tasks involving logins, security, compliance, disaster recovery, and performance monitoring.

Delivery Methods

Private Class
Delivered for your team at your site or online.

Microsoft Certified Partner

Webucator is a Microsoft Certified Partner. This class uses official Microsoft courseware and will be delivered by a Microsoft Certified Trainer (MCT).

Microsoft Certified Partner

Course Outline

  1. Design a SQL Server migration strategy
    1. Examine data platform modernization
    2. Plan a data migration
  2. Assess SQL Server databases for migration to Azure SQL
    1. Review database compatibility
    2. Explore assessment options for database migration
    3. Assess SQL Server with Azure Arc
    4. Assess a database with Azure Migrate
  3. Deploy IaaS solutions with Azure SQL
    1. Explain IaaS options for deploying SQL Server in Azure
    2. Understand hybrid scenarios
    3. Explore performance and security
  4. Deploy PaaS solutions with Azure SQL
    1. Explain PaaS options for deploying SQL Server in Azure
    2. Explore a single SQL database
    3. Deploy a SQL database elastic pool
    4. Understand SQL Database Hyperscale
    5. Examine SQL Managed Instance
  5. Migrate SQL Server workloads to an Azure virtual machine
    1. Review migration strategies and tools
    2. Migrate databases using native backup and restore
    3. Compare additional migration methods
  6. Migrate SQL Server workloads to Azure SQL Database
    1. Choose the appropriate Azure SQL Database feature
    2. Use Azure Database Migration Service to migrate to Azure SQL Database
    3. Migrate to Azure SQL Database using BACPAC
    4. Use an online migration method for Azure SQL Database
    5. Move data to Azure SQL Database
  7. Migrate SQL Server workloads to Azure SQL Managed Instance
    1. Evaluate migration scenarios
    2. Migrate using Azure Arc
    3. Migrate using Log Replay Service
    4. Migrate using Managed Instance link
    5. Move data to Azure SQL Managed Instance
  8. Perform post-migration tasks in Azure SQL
    1. Migrate SQL logins and groups
    2. Implement security to protect Azure SQL
    3. Implement compliance controls for sensitive data
    4. Monitor database performance

Class Materials

Each student receives a comprehensive set of materials, including course notes and all class examples.

Class Prerequisites

Experience in the following is required for this Azure class:

  • Ability to create an on-premises SQL Server database and configure its data and log files
  • Experience administering SQL Server databases
  • An Azure subscription for completing the exercises

Experience in the following would be useful for this Azure class:

  • Familiarity with on-premises virtualization technologies, including virtual machines, virtual networking, and virtual hard disks

Have questions about this course?

We can help with curriculum details, delivery options, pricing, or anything else. Reach out and we’ll point you in the right direction.

Talk to a Learning Consultant