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.

Introduction

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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.