Migrating SQL Server databases to the cloud
In the previous chapter, when we were migrating a .NET Framework app to the .NET 5 platform, we chose to migrate the least dependent component first. Then, in the next cycle, we migrated the components that relied on the components that were migrated in the previous cycle.
A similar approach works when migrating applications to the cloud as well. In the case of BookApp, the database can function on its own, but the application cannot function without the database. So, we will migrate the database to the cloud first. Then, in the next section, we will migrate the BookApp web application to the Azure cloud to complete the migration process.
Let's learn how to migrate the SQL Server database to the Azure cloud.
Comparing Azure SQL options
There are a number of SQL Server offerings on the Azure platform. Collectively, these are known as the Azure SQL family. Here is a brief introduction to the salient points of each offering...