Release: Data Migration Assistant (DMA) v5.2

This post has been republished via RSS; it originally appeared at: Microsoft Data Migration articles.

Overview

The Data Migration Assistant (DMA) helps you migrate to a modern data platform by detecting compatibility issues that can impact database functionality in your new version of SQL Server or Azure SQL.  DMA provides Azure SQL target readiness and helps to identify right Azure SQL for customer’s workload.

DMA recommends performance and reliability improvements for your target environment and allows you to move your schema, data, and uncontained objects from your source server to your target server.

What’s new in v5.2 ?

In this release of DMA, we added support for

  • Uploading assessments to Azure Migrate with support for Azure Government and national clouds (sovereign offering).  This feature enables to assess the readiness of SQL Server data estate migrating to Azure SQL.
    Upon clicking “Upload to Azure Migrate” button in DMA, you will see the drop down to select Azure Environment as shown below
    Rajesh Setlem_0-1588881650648.png
  • Command line support for uploading assessments to Azure Migrate with support for Azure Government and national clouds.  Now, you can completely automate uploading the assessments to Azure migrate project to get a consolidated Azure SQL readiness report. Check DMA command line documentation page for more information about the new arguments and examples.  

Supported source and target versions

  • Source: SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017, SQL Server 2019 and, RDS SQL Server
  • Target: SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017, SQL Server 2019, Azure SQL Database, Azure SQL Database Managed Instance

Installation

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

 

If you have any questions, comments or feedback do reach out to us at dmafeedback@microsoft.com

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *

*

This site uses Akismet to reduce spam. Learn how your comment data is processed.