The Data Migration Assistant (DMA) delivers scenarios that reduce the effort to upgrade to a modern data platform by detecting compatibility issues that can impact database functionality after an upgrade. It recommends performance and reliability improvements for your target environment.
DMA replaces the SQL Server Upgrade Advisor.
What's new in v1.0?
- Discovery of issues that can affect an upgrade to an on-premises SQL Server.These are described as compatibility issues categorized under these areas:
- Breaking changes
- Behavior changes
- Deprecated features
- Discovery of new features in the target SQL Server platform that the database can benefit from after an upgrade. These are described as feature recommendations and are categorized under these areas:
- Modern user experience to perform assessments.
You can install the tool from Microsoft Download Center. Execute sqladvisor.msi to install Data Migration Assistant.