Chapter 2. Migrating a SQL Server Database to an Azure SQL Database
Migrating an on-premises SQL Server Database is an important task and should be planned to perfection. An ideal migration methodology should be as shown in the following diagram:
![](https://static.packt-cdn.com/products/9781789538854/graphics/image_02_001.jpg)
Figure 2.1: Migration Methodology
By the end of this chapter, you will be able to:
Select a service tier for your migrated Azure SQL Database based on your needs
Explain Database Transaction Units
Identify and fix SQL Server to Azure SQL Database compatibility issues
Migrate from on-premises database to Azure SQL Database using different tools