CloudTeam

Main menu

Contact

TrainingData & analytics / Data & AIDP-3001

DP-3001Microsoft · authorised training

Migrate SQL Server workload to Azure SQL

You will explore different migration tools and migrate SQL Server databases to Azure SQL Database.

Duration
1 day
Level
Intermediate
Provider
Microsoft
Topic
Data & analytics / Data & AI

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
  • Summary

Skills you will gain

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