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.