Migrate SQL Server Workloads to Azure SQL Database – Intensive Training («DP3X1»)

• Exploring the advantages, capabilities, and migration possibilities offered by Azure SQL Database
• Migrating databases using Azure SQL Migration extension for Azure Data Studio and tracking database migration activities
• Using transactional replication as an online method to migrate to Azure SQL Database
• Exploring several other methods for migrating SQL Server databases to Azure SQL Database

Learn how to assess SQL Server components and compatibility for migration using the Azure SQL Migration Extension and Database Migration Assistant. You will also learn how to provision and configure Azure SQL resources. You will 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 will 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.

1 Design a SQL Server migration strategy
In this module, you'll learn the phases of a migration and the steps involved to ensure your migration project is executed smoothly. You'll also learn the purpose of data platform modernization and see the benefits it can bring to your organization.

2 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.

3 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.

4 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.

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

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

7 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.

8 Perform post-migration tasks on Azure SQL
You'll explore different features and tools to help you maintain Azure SQL environments.

This course is aimed at administrators, data engineers, developers and solution architects.

• 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

This workshop is integrated into the course AZ-305: Designing Microsoft Azure Infrastructure Solutions.