Assess SQL Server databases for migration to Azure SQL

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

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.

Learning objectives

In this module, you'll:

  • Understand common compatibility issues and blockers that may prevent a migration to Azure SQL.
  • Discover the various tools and options available for assessing SQL Server databases for migration purposes.
  • Use the Azure migration extension for Azure Data Studio to assess SQL Server databases.
  • Use the Azure Migrate and other tools to assess SQL Server databases.

Prerequisites

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