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:

Migrating a SQL Server Database to an Azure SQL Database

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.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
18.191.215.96