Summary
Migrating to an Azure SQL Database or SQL Managed Instance is an important task and should be planned to perfection. This chapter talked about the migration strategy that you should follow when migrating from an on-premises database to an Azure SQL Database or SQL Managed Instance. A good database migration strategy includes the following steps: determining the migration benefits, selecting the right destination by choosing the correct pricing model and service tier, choosing primary and disaster recovery regions to deploy resources to, determining compatibility issues, and selecting a migration tool based on the migration approach.
In this chapter, we talked about assessment tools. We saw various ways to perform online/offline database migration to Azure SQL Database and SQL Managed Instance. We also covered different migration tools to migrate the data and the schema from an on-premises SQL Server database to an Azure SQL Database and SQL Managed Instance.
In the next...