08 How do I approach migration? Chapter 05
Figure 2: Three-step cloud migration strategy from Microsoft
Discover Plan Analyze Migrate schema,
data, and objects
Remediate
applications
Optimize
Run functional &
performance tests
Assess Migrate
Optimize
The first step toward migration is to understand your database footprint,
discover on-premises database servers, and identify app and server
dependencies. Then, you need to plan and analyze whether the targeted Azure
SQL Database Managed Instance is compatible with the database requirements
of your application. It's important to understand your database performance
needs and to determine how you would deliver that performance on Azure
after migration. In the case of Azure SQL Database Managed Instance, this
might require computing the number of vCores needed for each database.
If you have specific security or regulatory requirements, you also need to
consider them during the assessment process. To achieve these goals, Microsoft
has made available many resources and tools, including:
Azure Database Migration Guide
This one-stop guide for database migration provides step-by-step guidance
from source to target. It also showcases recommended partners and
customer case studies. View the Database Migration Guide.
Step 1: Assess
