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
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
You can install the tool from Microsoft Download Center. Run the DataMigrationAssistant.msi file to install the Data Migration Assistant.