home > training > DP-3001: Migrate SQL Server workloads to Azure SQL
Print Page

Migrate SQL Server workloads to Azure SQL

MOC: DP-3001

$675

  • 1 Day
  • Replay™ Class Recordings Included
  • Included in the "all-you-can-eat" Microsoft Live Training Subscription Learn More

Interface Gold™Gold Benefits: Retake this course for one year. Replay™ class recordings included. Money-back guarantee. Price Match available. MS SubscriptionIncluded in the "all-you-can-eat" Microsoft Live Training Subscription.

Interested in scheduling a date for this course?
Request A Date
Register today - no risk!  No cancellation fees.  Full money back guarantee!
x
Course:
  • This field is for validation purposes and should be left unchanged.

Course Description

The course is designed as a blended learning experience that combines instructor-led training with online materials on the Microsoft Learn platform (https://docs.microsoft.com/learn). Students are encouraged to use the content on Learn as reference materials to reinforce what they learn in class and to explore topics in more depth.

Outline

Assess SQL Server databases for migration to Azure SQL

Assessment tools such as Azure SQL Migration extension for Azure Data Studio, Azure Migrate, and Data Migration Assistant facilitate the migration of SQL Server databases to Azure.

Lessons

  • Review database for compatibility
  • Explore assessment options for database migration
  • Assess a database with Azure Migration extension
  • Assess a database with Azure Migrate
  • Assess a database with Data Migration Assistant

Exercise

  • Identify compatibility issues

 

Deploy IaaS solutions with Azure SQL

Configure virtual machine sizing, storage, and networking options to ensure adequate performance for your database workloads. Choose and configure appropriate high availability options.

Lessons

  • Explain IaaS options to deploy SQL Server in Azure
  • Understand hybrid scenarios
  • Explore performance and security
  • Explain high availability and disaster recovery options

Exercise

  • Provision a SQL Server on an Azure Virtual Machine

 

Deploy PaaS solutions with Azure SQL

Provision and deploy Azure SQL Database and Azure SQL managed instance. Select the appropriate options when performing a migration to the SQL PaaS platform.

Lessons

  • Explain PaaS options for deploying SQL Server in Azure
  • Explore single SQL database
  • Deploy SQL database elastic pool
  • Understand SQL database hyperscale
  • Examine SQL managed instance
  • Describe SQL Edge

Exercise

  • Deploy an Azure SQL Database

 

Migrate SQL Server workloads to Azure Virtual Machine

You will explore different migration tools and migrate SQL Server databases to Azure Virtual Machine.

Lessons

  • Review migrations strategies and tools
  • Explore Azure SQL Migration extension for Azure Data Studio
  • Understand Data Migration Assistant
  • Understand distributed availability group for migration
  • Migrate databases using native backup and restore
  • Compare additional migration methods

Exercise

  • Migrate SQL Server databases to SQL Server on Azure Virtual Machine

 

Migrate SQL Server workloads to Azure SQL Database

You will explore different migration tools and migrate SQL Server databases to Azure SQL Database.

Lessons

  • Choose the right Azure SQL Database feature
  • Use Azure SQL migration extension to migrate to Azure SQL Database
  • Explore Data Migration Assistant to migrate to Azure SQL Database
  • Migrate to Azure SQL Database using BACPAC
  • Use an online method to migrate to Azure SQL Database
  • Move data to Azure SQL Database

Exercise

  • Migrate a SQL Server database to Azure SQL Database

 

Migrate SQL Server workloads to Azure SQL Managed Instance

You'll explore different migration tools and migrate SQL Server databases to Azure SQL Managed Instance.

Lessons

  • Evaluate migration scenarios
  • Use Log Replay Service (LRS) to migrate
  • Migrate using Managed Instance link
  • Move data to SQL Managed Instance

Exercise

  • Migrate a SQL Server database to Azure SQL Managed Instance

 

Perform post-migration tasks on Azure SQL

You'll explore different features and tools to help you maintain Azure SQL environments.

Lessons

  • Migrate SQL logins and groups
  • Implement security to protect Azure SQL
  • Implement compliance controls for sensitive data
  • Monitor database performance
  • Configure high availability and disaster recovery
  • Automate database tasks for scalability

Exercise

  • Configure geo-replication for Azure SQL Database
Audience

As the Azure database administrator, you implement and manage the operational aspects of cloud-native and hybrid data platform solutions built on SQL Server and Azure SQL services. You use a variety of methods and tools to perform and automate day-to-day operations, including applying knowledge of using Transact-SQL (T-SQL) and other tools for administrative management purposes.

Prerequisites

Before attending this course, students must have:

  • Experience in administering SQL Server databases.
  • Experience of working with Microsoft Azure services.