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:
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
Finding the Migration Benefits
You
should first analyze and find out the benefits of migrating an on-premises SQL Database to an Azure SQL Database. Migration involves a lot of time, effort, and cost, and it shouldn't be done just for the sake of having a cloud database.