DP-3001: Migrate SQL Server workloads to Azure SQL Database
Course Description
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.
About this Course
Course Outline
- 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
Duration
1 Day
Prerequisites
- Experience in administering SQL Server databases.
- Knowledge of SQL Server editions and versions.
- Knowledge of basic T-SQL.
Level
Advanced
Product
SQL Server