Important! Selecting a language below will dynamically change the complete page content to that language.
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.
DataMigrationAssistant.msi
-
What is new in V5.5?
- Added a new elastic SKU recommendation model that generates an unique price-to-performance curve based on heuristic analysis of the collected performance data and workload pattern comparison with workloads in Azure SQL.
- Improved user experience with a new HTML report for SKU recommendation results, in addition to the existing JSON file output.
- Added connection string wizard to enable users to intuitively provide SQL connection information for single SQL instances when starting SKU recommendation data collection.
- Added the ability to select databases to include/exclude when computing SKU recommendations.
- Deprecation of SQL Server 2005 as a source and removal in the future releases of DMA.
What issues have been fixed in v5.5？
- Removed obsolete rules and optimized assessment algorithm for Azure SQL Database and Azure SQL Managed Instance.
- Fixed an error preventing collected performance data for SKU recommendations from being read correctly in certain locales.
- Fixed an issue related to incorrect SKU recommendations for environments with highly variable workload patterns.
- Fixed an issue affecting data collection for SKU recommendations in high memory environments.
Documentation
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
Supported Operating System
Windows Server 2016, Windows 10, Windows Server 2012, Windows 7, Windows 8, Windows 8.1
-
Windows 7 64-bit (or Windows Server 2012) and above
.NET Framework 4.7.2 64-bit or above
.NET Core 3.0 64-bit or above
Recommended resolution (1024x756)
-
Download and run the DataMigrationAssistant.msi package.
