First published on MSDN on Oct 16, 2018
Authored by rajpo@microsoft.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).
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:
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]
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.