Migrate SQL Server workloads to Azure SQL Database

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

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

Learning objectives

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

Prerequisites

  • Experience in administering SQL Server databases.
  • Knowledge of SQL Server editions and versions.
  • Knowledge of basic T-SQL.