EIEIOTECHNOVATION
← Training programmes

EIEIO / DATA SCIENCE

Migrate SQL Server workload to Azure SQL

Reference course outline

DP-30011 day
Discuss this programme →

Duration

1 day

Overview

In this module, learn about the key elements of DevOps culture and how they promote collaboration, transparency, shared responsibility, and continuous learning. The module covers topics such as collaboration, transparency, alignment, shared responsibility, accountability, empowerment, continuous learning, measurable outcomes, customer-centric focus, agility, automation, and security integration. Also, explore the value that DevOps brings to organizations, including accelerated time to market, adaptability to market dynamics, stability and reliability in operations, and minimizing mean time to recovery (MTTR). Additionally, understand how DevOps practices optimize application lifecycle management, impacting every phase from planning to operations.

By the end of this module, have a clear understanding of the principles, practices, and values of DevOps and how they can be applied to optimize software delivery and improve collaboration between development and operations teams.

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

Prerequisites

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

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

Summary

In our bike manufacturing scenario, you created and executed a plan to migrate your servers to Azure SQL Database using both offline and online methods.

Now, with the migration complete, your users have the best availability and scalability for their data and you're confident that you can respond to future changes in demand quickly. The method chosen to migrate the database is typically dependent on how much time the SQL Server databases can be offline.

For additional reading, you can refer to the following resources:

  • Migration overview: SQL Server to Azure SQL Database
  • Azure SQL migration extension for Azure Data Studio
  • Data Migration Assistant
  • Transactional Replication with Azure SQL Database

This is a version-specific reference outline. Confirm the current syllabus and delivery arrangements with EIEIO.