First published on MSDN on Oct 16, 2018
Authored by email@example.com
The Data Migration Assistant (DMA) provides a comprehensive assessment by detecting compatibility and functionality issues prior to migrating to a specific version of SQL Server, Azure SQL Database, or Azure SQL Database Managed Instance. The tool recommends performance and reliability improvements for your target environment. DMA allows you to move the schema, data, and uncontained objects from your source server to your target server. DMA replaces all previous versions of the SQL Server Upgrade Advisor (SSUA) and should be used to upgrade most versions of SQL Server (see below for supported versions).
What's new in v4.1?
The v4.1 release of DMA introduces support for comprehensive assessment of migrating on-premises SQL Server databases to Azure SQL Database Managed Instance.
The assessment workflow helps you detect the following issues, which can affect your migration to Azure SQL Database Managed Instance:
Unsupported or partially supported features . DMA assesses your source SQL Server database for features in use that are partially supported or unsupported on the target Azure SQL Database Managed Instance. The tool then provides a comprehensive set of recommendations, alternative approaches available in Azure, and mitigating steps so that customers can take this information into account when planning their migration projects.
DMA also identifies compatibility issues related to the following areas:
- Breaking changes: The specific schema objects that may break the functionality migrating to the target database. We recommend fixing these schema objects after the database migration.
- Behavior changes: The schema objects reported may continue to work, but they may exhibit a different behavior, for example performance degradation.
- Informational issues: These objects will not impact the migration but may have been deprecated from feature SQL Server releases.
After the assessment is complete, use our Azure Database Migration Service (DMS) to perform the migration of your SQL Server databases to Azure SQL Database Managed Instance. DMS supports both offline (one-time) and online (minimal-downtime) database migrations to Azure SQL Database Managed Instance.
Watch our short video How to assess on-premises SQL Server migrating to Azure SQL Database Managed Instance using DMA.
[video width="1154" height="720" mp4="https://msdnshared.blob.core.windows.net/media/2018/10/DMAAssessMI.mp4"][/video]
Supported source and target versions
Sources : SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, SQL Server 2016, and SQL Server 2017 on Windows.
Targets : SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017 on Windows and Linux, Azure SQL Database and 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.