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

Modules

• Introduction
• Choose the right Azure SQL Database feature
• Use Azure SQL migration extension to migrate to Azure SQL Database
• Explore Data Migration Assistant to migrate to Azure SQL Database
• Migrate to Azure SQL Database using BACPAC
• Use an online method to migrate to Azure SQL Database
• Move data to Azure SQL Database
• Exercise - Migrate a SQL Server database to Azure SQL Database
• Knowledge check
• Summary