MEAPSA

Evaluate strategies for migrating SQL Databases to Azure

Describe database migration options and tools on Azure. Understand how compatibility level affects database behavior. Describe Azure private and public preview options.

Database Administrator

Data Engineer

Azure

SQL Server

SQL Database

SQL Managed Instance

SQL Server on Virtual Machines

Module Objectives

After completing this module, you will be able to:

Evaluate different Azure migration options when moving your on-premises SQL environment to the cloud.
Understand how SQL Server compatibility level affects database behavior.
Understand the differences between private and public preview options.

Units

Introduction min
Understand compatibility level min
Understand Azure preview features min
Describe Azure database migration options min
Knowledge check min
Summary min

Prerequisites

Experience creating and configuring resources using the Azure portal.
Ability to create a on-premises SQL Server database.
Ability to write SQL statements at a beginner level.