Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Important
Data Migration Assistant (DMA) is deprecated. For migration options from SQL Server to Azure SQL, see the migration options for SQL Server to Azure SQL.
This article lists the additions in each release of Data Migration Assistant.
The v5.6 release of the Data Migration Assistant provides support for:
In addition, this release of Data Migration Assistant provides bug fixes and improvements for the following issues:
The v5.5 release of the Data Migration Assistant provides support for:
In addition, this release of Data Migration Assistant provides bug fixes and improvements for the following issues:
The v5.4 release of the Data Migration Assistant provides support for:
In addition, this release of Data Migration Assistant provides bug fixes for the following issues:
specified value for 'AssessmentDatabases' is invalid
error when using AssessTargetReadiness option in DMA command line.The v5.3 release of the Data Migration Assistant provides support for:
In addition, this release of Data Migration Assistant is updated to .NET 4.8 and provides bug fixes for the following issues:
The v5.2 release of the Data Migration Assistant provides support for:
The v5.0 release of the Data Migration Assistant provides support for:
In addition, this release of Data Migration Assistant provides extra enhancements and bug fixes, and the tool is updated to .NET 4.7.2.
The v4.5 release of Data Migration Assistant provides support for assessment of migrating SQL Server Integration Services (SSIS) packages hosted in File system to Azure SQL Database or SQL Managed Instance.
The v4.4 release of Data Migration Assistant provides support for uploading assessments to Azure Migrate.
The v4.3 release of Data Migration Assistant provides support for:
ignoreErrorCodes
property configured in DMA doesn't show up in DMA assessment results.In addition, this release of DMA provides improved performance for handling a large number of schema objects in databases, and bug fixes related to:
The v4.2 release of Data Migration Assistant provides command-line support for target readiness assessment for one or more server instances when migrating from on-premises SQL Server to a SQL Managed Instance. Customers can now use the Data Migration Assistant command line to collect metadata about their database schema, detect the blockers, and learn about partially supported or unsupported features that affect migration to a SQL Managed Instance. The results can then be rendered using the Power BI template provided.
The v4.1 release of Data Migration Assistant introduces support for comprehensive assessment of on-premises SQL Server databases migrating to SQL Managed Instance.
The assessment workflow helps you detect the following issues, which can affect your migration to SQL Managed Instance:
Unsupported or partially supported features. Data Migration Assistant assesses your source SQL Server database for features in use that are partially supported or unsupported on the target SQL 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.
Compatibility issues. Data Migration Assistant 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 SQL Managed Instance. DMS supports both offline (one-time) and online (minimal-downtime) database migrations to SQL Managed Instance.
The v4.0 release of Data Migration Assistant introduces the Azure SQL Database SKU recommendations feature, which allows users to identify the minimum recommended Azure SQL Database SKU based on performance counters collected from the computers hosting your databases. This feature provides recommendations related to pricing tier, compute level, and max data size, and estimated cost per month. It also offers the ability to provision all your databases to Azure in bulk.
Note
This functionality is currently be available only via the Command Line Interface (CLI).
For more information, see Identify the right Azure SQL Database SKU for your on-premises database.
The v3.6 release of Data Migration Assistant introduces "Auto fix" for the schema objects that are affected by the most common migration blockers.
This release provides autofix for the following migration blocker and behavior change issues:
Data Migration Assistant performs automatic schema conversion for the objects affected by the listed issues and prompts the user for confirmation before proceeding with the schema conversion. Users can review the suggested code changes and then either accept or reject all conversions for any given database object.
Data Migration Assistant uses Microsoft Program Synthesis (PROSE) technology to suggest the code fixes. Learn more about PROSE.
The v3.5 release of Data Migration Assistant includes the following additions:
The v3.4 release of Data Migration Assistant includes the following additions:
The v3.3 release of Data Migration Assistant enables migration of an on-premises SQL Server instance to the new version of SQL Server 2017, on both Windows and Linux. While the overall migration workflow for Windows and Linux is the same, the move to SQL Server 2017 for Linux requires a couple of additional considerations.
Linux and Windows use different path formats. As a result, migrating to SQL Server 2017 on Linux requires that the user provide both the Windows and Linux versions of the path to the location of the physical file. You can provide both versions of the path in different ways depending on the location of the physical file. If the physical back-up file is on a computer running:
samba
share to share the file with other computers on the network.mnt
command to mount the share onto the computer running Linux.Note
Details of using a samba
share or the mnt
command are beyond the scope of this article.
While the migration of Active Directory (AD) logins is officially supported by SQL Server 2017 on Linux, it requires additional configuration to work successfully. Refer to the article Active Directory Authentication with SQL Server on Linux for detailed information about setting up Active Directory logins on SQL Server 2017 on Linux. After you perform the required configuration, the setup is complete and you can migrate Active Directory logins as usual. Standard SQL Authentication works as expected without any extra setup.
The v3.2 release of Data Migration Assistant includes the following additions:
The v3.1 release of Data Migration Assistant includes the following additions:
The v3.0 release of Data Migration Assistant extends the Azure SQL Database assessment to provide comprehensive recommendations to help fix issues related to:
The v2.1 release of Data Migration Assistant includes the following additions:
The v2.0 release of Data Migration Assistant includes improved Stretch database feature recommendations to provide proper prioritized tables that maximize the storage savings.
Important
Stretch Database is deprecated in SQL Server 2022 (16.x) and Azure SQL Database. This feature will be removed in a future version of the Database Engine. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
The v1.0 release of Data Migration Assistant is the initial release, and it provides for:
Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayTraining
Module
Assess SQL Server databases for migration to Azure SQL - Training
Learn multiple assessment tools that facilitate the migration of databases to Azure, including the Azure SQL Migration extension for Azure Data Studio, Azure Migrate, and Data Migration Assistant.
Certification
Microsoft Certified: Azure Database Administrator Associate - Certifications
Administer an SQL Server database infrastructure for cloud, on-premises and hybrid relational databases using the Microsoft PaaS relational database offerings.