-
Book Overview & Buying
-
Table Of Contents
-
Feedback & Rating

Professional Azure SQL Managed Database Administration
By :

Migrating an on-premises SQL Server database is an important task and should be planned to perfection. An ideal migration methodology should be like the one shown in Figure 3.1:
Figure 3.1: Migration methodology
We will discuss each of these steps now.
You should first identify and analyze the benefits of migrating an on-premises SQL database to 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.
The next step is to decide whether the database will be deployed individually, in an elastic pool, or as an SQL Managed Instance. This is important as the service model will affect the overall pricing, service tier, performance, and management of the database.
The next step is to find an appropriate service tier and performance level for Azure...