Cart 0
Training
DP-3001: Migrate SQL Server workloads to Azure SQL
Course Information
Course Name
DP-3001: Migrate SQL Server workloads to Azure SQL
Duration
1 Day
Overview
Audience Profile
Prerequisities
At Course Completion
Course Outline
Overview
You’ll learn how to assess SQL Server components and compatibility for migration using the Azure SQL Migration Extension and Database Migration Assistant. You’ll also learn how to provision and configure Azure SQL resources. You’ll gain hands-on experience in choosing the best migration option to meet business requirements for downtime, handling migration state, and monitoring database migration.
Additionally, you’ll also learn to perform post-migration tasks like disaster recovery and monitoring. These skills are essential for ensuring a smooth, efficient transition to Azure SQL, and maintaining its operation post-migration.
Overview
Overview
You’ll learn how to assess SQL Server components and compatibility for migration using the Azure SQL Migration Extension and Database Migration Assistant. You’ll also learn how to provision and configure Azure SQL resources. You’ll gain hands-on experience in choosing the best migration option to meet business requirements for downtime, handling migration state, and monitoring database migration.
Additionally, you’ll also learn to perform post-migration tasks like disaster recovery and monitoring. These skills are essential for ensuring a smooth, efficient transition to Azure SQL, and maintaining its operation post-migration.
Audience Profile
Prerequisities
Prerequisites
- Experience with SQL Server databases.
- Knowledge of SQL Server editions and versions.
- Basic knowledge of security concepts like identities and permissions.
- Experience using the Azure portal to create resources and set permissions.
At Course Completion
At Course Completion
In this module, you’ll:
- Explore the advantages, capabilities, and migration possibilities offered by Azure SQL Database.
- Migrate databases using Azure SQL Migration extension for Azure Data Studio and tracking database migration activities.
- Use the Data Migration Assistant (DMA) tool to facilitate SQL Server migrations to Azure SQL Databas.
- Use transactional replication as an online method to migrate to Azure SQL Database
- Explore several other methods for migrating SQL Server databases to Azure SQL Database.
Course Outline
Course Outline
Module 1: Design a SQL Server migration strategy
Module 2: Assess SQL Server databases for migration to Azure SQL
Module 3: Deploy IaaS solutions with Azure SQL
Module 4: Deploy PaaS solutions with Azure SQL
Module 5: Migrate SQL Server workloads to Azure Virtual Machine
Module 6: Migrate SQL Server workloads to Azure SQL Database
Module 7: Migrate SQL Server workloads to Azure SQL Managed Instance
Module 8: Perform post-migration tasks on Azure SQL
