Once you have finalized the Service tier, the next step is to migrate both schema and data from the on-premises SQL Database to the Azure SQL Database. As we learned in Chapter 1 Microsoft Azure SQL Database Primer, not all features are the same and supported on the Azure SQL Server. Therefore, you will first have to do a compatibility test or assessment to find and fix the compatibility issues.
The following are the available tools to detect compatibility issues. However, these tools can be used to migrate the database as well; in this section, though, we'll talk about assessing compatibility.
Data Migration Assistant (DMA) is a standalone tool for detecting compatibility issues and to migrate on-premises SQL Server Databases to Azure SQL Databases. It provides a wizard-type easy-to-use graphical user interface for compatibility assessment and migration.
It detects and highlights compatibility issues. Once all of the compatibility...