Chapter 2

Migrating a SQL Server Database to an Azure SQL Database

Learning Objectives

By the end of this lesson, you will be able to:

  • Select a service tier for your migrated Azure SQL Database based on your needs
  • Explain Database Transaction Units (DTUs)
  • Identify and fix SQL Server-to-Azure SQL Database compatibility issues
  • Migrate from an on-premises database to Azure SQL Database using different tools

In this lesson, you'll learn how to find and fix compatibility issues, determine an appropriate service tier, figure out a migration strategy and tool and migrate to the cloud.


Migrating an on-premises SQL Server database is an important task and should be planned to perfection. An ideal migration methodology should be like ...

Get Professional Azure SQL Database Administration - Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.