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.7?
- Added SQL Server 2022 as source and target platform to support SQL Server 2022 assessment and migration.
- Added support for assessing and recommending Hyperscale tier for Azure SQL SKUs.
What issues have been fixed in v5.7?
- Fixed accessibility issues.
- Fixed agent jobs assessment bug.
- Fixed feature-rule mapping mismatch issue.
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, SQL Server 2022 and, Amazon RDS for SQL Server
- Target: SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017, SQL Server 2019, SQL Server 2022, 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 Server 2019, Windows Server 2022
-
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.