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

microsoft applied skills
Microsoft Instructor-led Training

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

  • 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 class for your team.