Released: Data Migration Assistant (DMA) v3.2


Overview

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 allows you to not only move your schema and data, but also uncontained objects from your source server to your target server. DMA replaces all previous versions of SQL Server Upgrade Advisor (SSUA) and should be used for upgrades for most SQL Server versions (see below for supported versions).

What's new?

DMA enables migration of your on-premises SQL Server instance to an Azure SQL Database instance accessible from your on-premises network (via VPN or other technologies).

With this release, a new migration workflow has been added to help you move the following components to Azure SQL Database:

1. Schema and data of databases
2. Database users (Windows users will be converted to Azure Active Directory users on the target, if possible)
3. Database and application roles, as well as role memberships
4. Database-level and object-level permissions
5. SQL logins mapped to any migrated SQL users

You can connect to target Azure SQL Databases with Azure Active Directory authentication or SQL authentication.
When the migration is completed successfully, applications will be able to connect to the target Azure SQL Database instances seamlessly.

Existing Features

Data Migration Assistant (DMA) v3.1

Data Migration Assistant (DMA) v3.0

Data Migration Assistant (DMA) v2.1

Data Migration Assistant (DMA) v2.0

Data Migration Assistant (DMA) v1.0

Supported sources 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, SQL Server 2016, and Azure SQL Database

Installation

You can install the tool from Microsoft Download Center. Execute DataMigrationAssistant.msi to install Data Migration Assistant.

Resources

Comments (7)

  1. Mikelasy says:

    This information is the very helpful for me and the gain the information.
    Thank you

  2. Linda_LF says:

    The text states : [see below for supported versions], but I don’t see them listed?

    1. Harini Gupta says:

      Thanks for calling that out – its updated now.

  3. sgiles says:

    Are there any plans to add Azure Data Warehouse to the list of destinations?

    1. Gennady Kostinsky says:

      Its in our plans, together with other enhancements.

  4. Daryl Maunder says:

    The download link appears to be broken

    1. I just checked that the link to the DMA 3.2 page in the Download Center works properly. Can you provide any additional detail about the errors you are experiencing? Thanks!

Skip to main content