You can assess your on-premises SQL Server databases from Azure Migrate using Microsoft's Database Migration Assistant (DMA). Your on-premises databases can be assessed for migration to Azure SQL DB, Azure SQL managed instances, or Azure VMs running SQL Server. DMA allows you to do the following:
- Assess on-premises SQL Server instances for migrating to Azure SQL databases. The assessment workflow helps you to detect migration blocking issues, as well as partially supported or unsupported features.
- Discover issues that can affect an upgrade to an on-premises SQL Server. These are organized into different categories: breaking changes, behavior changes, and deprecated features.
- Assess on-premises SQL Server Integration Services (SSIS) packages that can be migrated to an Azure SQL Database or Azure SQL Database managed instance.
- Discover new features in the target SQL Server platform that the database can benefit from after an upgrade.