Professional Azure SQL Database Administration
上QQ阅读APP看书,第一时间看更新

Summary

Migrating to an Azure SQL database is an important task and should be planned to perfection. This lesson talked about a migration strategy that you should follow when migrating from an on-premises database to an Azure SQL database:

  1. Find the migration benefits.
  2. Find the blockers.
  3. Select a service model.
  4. Select a service tier.
  5. Select the main region and the disaster recovery region.
  6. Select a migration tool.

This lesson also talked about how to choose a service tier and covered different migration tools to migrate the data and the schema from an on-premises SQL Server database to an Azure SQL database. In the next lesson, we will learn how to perform manual and automatic backups that are unique to Azure SQL databases.