Migrate SQL Server workloads to Azure SQL Database
You will explore different migration tools and migrate SQL Server databases to Azure SQL Database.
Administrator
Data Engineer
Database Administrator
Developer
Solution Architect
SQL Server
SQL Database
Module 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.
Units
Prerequisites
- Experience in administering SQL Server databases.
- Knowledge of SQL Server editions and versions.
- Knowledge of basic T-SQL.