Azure Training | Microsoft 365 Training | Power Platform Training | Dynamics 365 Training
Contact us

Microsoft Azure Training

DP-3001: Migrate SQL Server workloads to Azure SQL Database

This module covers exploring Azure SQL Database’s advantages and migration possibilities, using Azure SQL Migration extension and transactional replication for database migration, and other methods for migrating SQL Server databases to Azure SQL Database.

REQUEST GROUP TRAINING
Microsoft Instructor-led Training | Microsoft Azure Training | Microsoft 365 Training | Microsoft Azure AI Training | Microsoft Power Platform Training | Microsoft Dynamics 365 Training

Course Description

Do You Even Synapse?​

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

  • 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

1 Day

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

Advanced

SQL Server

Need to Train a Team?

Contact us to schedule a dedicated Microsoft Azure Training for your team.

Contact us