First published on MSDN on Jul 10, 2018
Authored by email@example.com
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).
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:
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/ .
You can install the tool from Microsoft Download Center . Run the DataMigrationAssistant.msi file to install the Data Migration Assistant.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.