Home
Microsoft

Overview

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 v4.3?

The v4.3 release of DMA provides support for:

  • SKU Recommendations for Azure SQL Database managed instances based on workload assessment.
  • RDS SQL Server as a source for assessments.
  • Agent job assessments for Azure SQL Database managed instance as a target.
  • The ability to ignore certain assessment rules; the list of error codes specified in the 'ignoreErrorCodes' property configured in DMA will not show up in DMA assessment results.
  • Assessment of T-SQL queries in job activity steps and providing appropriate recommendations
  • Extended events assessments (Public Preview).
  • Assessment of Cassandra sources for migration to Azure Cosmos DB migration via the Target Readiness Assessment command line workflow (Private Preview). Customers wishing to participate in the private preview should contact askcosmosdb@microsoft.com to enable this functionality.

In addition, this release of DMA provides improved performance for handling large number of schema objects in databases, as well as bug fixes related to:

  • Procedures compiled with native compilation, in some cases.
  • Complicated database schemas.

 

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.

 

Installation

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

 

Resources

2 Comments
Occasional Visitor

I'm having an issue consuming the json to an Azure SQL Database. I get the following in PowerShell:

Error writing results for file "****" to database.

 

 

Microsoft

@jkapernicus, I am sorry to hear that you are experiencing an issue using the latest version of DMA. Please email the Data Migration Assistant Feedback alias <dmafeedback@microsoft.com> and someone will get back to you soon.  Thanks!