The Data Migration Assistant 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 the SQL Server Upgrade Advisor and should be used for upgrades for most SQL Server versions (see below for supported versions).
What's new in v2.1?
DMA v2.1 is a minor version update and includes following:
- DMA 2.1 provides a command-line support for running assessments in an unattended mode. This feature helps to run the assessments at scale.
Continue to use the DMA 2.1 UI version of the tool for performing the database migrations.
- How to use dmaccmd.exe ? please refer to Data Migration Assistant: How to run from command line
- Perf improvements made when users launch and close DMA tool.
- Ability to configure SQL connection time-out. Refer to Data Migration Assistant: Configuration settings for more details.
Supported source and target versions
Source: SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, and SQL Server 2016
Target: SQL Server 2012, SQL Server 2014, and SQL Server 2016
You can install the tool from Microsoft Download Center. Execute DataMigrationAssistant.msi to install Data Migration Assistant.