Data Migration Assistant (DMA) enables you to upgrade to a modern data platform by detecting compatibility issues that can impact database functionality on your new version of SQL Server. It recommends performance and reliability improvements for your target environment. It also allows you to not only move your schema, data, but also uncontained objects from your source server to your target server.
DMA replaces all previous versions of SQL Server Upgrade Advisor and should be used for upgrades for most SQL Server versions (see below for supported versions).
What is new with this release?
DMA v3.1 is a minor version update and includes following additions:
- Improved assessment recommendations for Azure SQL Databases around database collations, use of unsupported system stored procedures, and CLR objects.
- Added assessment guidance for compatibility levels 130, 120, 110 and 100 migrating to Azure SQL Databases.
For more information see this post.
Ajay Jagannathan (@ajaymsft)
Principal Program Manager