Migrate SQL Server workloads to Azure SQL

Intermediate
Administrator
Data Engineer
Database Administrator
Developer
Solution Architect
Azure SQL Database
Azure Virtual Machines
SQL Server

This learning path prepares you for the task of migrating SQL Server workloads to Azure SQL.

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.

Note

You need an Azure subscription to complete the exercises. If you don't have an Azure subscription, create a free account and add a subscription before you begin. If you're a student, you can take advantage of the Azure for students offer.

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.

Modules in this learning path

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.

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.

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

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

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

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

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

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