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.6?
- Added new premium-series and premium-series memory optimized Azure SQL Managed Instance preview SKUs to SKU recommendation feature.
- Added new E v5 and Eb v5 (preview) SQL Server on Azure Virtual Machine SKUs to SKU recommendation feature.
- Added feature flag to SKU recommendation console app to toggle whether or not new preview SKUs are considered.
- Improved the SKU recommendation logic for SQL Server on Azure Virtual Machine to better align with best practices. Learn more.
What issues have been fixed in v5.6?
- Fixed CPU utilization calculation causing incorrect SKU recommendation results.
- Fixed case-sensitive collation issue causing data collection to fail during SKU recommendation.
- Fixed accessibility issues.
- Fixed Azure SQL Database migration row count mismatch.
- Fixed T-SQL parser bug.
- Changed some blocking issues to warnings.
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.