Migrating data
SQL Server is one of the most common database types for older, on-premises-based solutions. In the previous chapter, we also discussed NoSQL-based databases, which include products such as MongoDB or Azure Cosmos DB. However, NoSQL databases work differently, and often, the only way to migrate NoSQL to SQL, or SQL to NoSQL, would be customizing code to read the source data and write to the destination.
Although this is, of course, possible, often your solution will be designed with the underlying technology in mind; therefore, we will instead assume you are looking to migrate from a SQL-based solution to an Azure-hosted SQL solution.
We already discussed some of the different options we have in Azure for hosting SQL databases; as a recap, they are Azure SQL Database, Azure SQL Managed Instance, or SQL Server on a VM.
When choosing our desired source, we need to consider several requirements, such as the following:
- Compatibility—Does your on-premises...
