The 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. The tool recommends performance and reliability improvements for your target environment. DMA allows you to move your schema, data, and uncontained objects from your source server to your target server. DMA replaces all previous versions of the SQL Server Upgrade Advisor (SSUA) and should be used to upgrade most versions of SQL Server (see below for supported versions).
What's new in v3.6?
The v3.6 release of DMA introduces “Auto fix” for the schema objects that are impacted by the most common migration blockers.
This release provides auto-fix for the following migration blocker and behavior change issues:
- The schema objects that use Unqualified Join syntax.
- The schema objects that use the legacy RAISEERROR statement.
- SQL statements that use Order By Integer Literal.
DMA performs automatic schema conversion for the objects impacted by the issues above and prompts the user for confirmation before proceeding with the schema conversion. Users can review the suggested code changes and then either accept or reject all conversions for any given database object.
DMA uses Microsoft Program Synthesis (PROSE) technology to suggest the code fixes. Learn more about PROSE at https://microsoft.github.io/prose/.
Supported source and target versions
Sources: SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, SQL Server 2016, and SQL Server 2017 on Windows.
Targets: SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017 on Windows and Linux, and Azure SQL Database.
You can install the tool from Microsoft Download Center. Run the DataMigrationAssistant.msi file to install the Data Migration Assistant.