The 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. The tool recommends performance and reliability improvements for your target environment. DMA allows you to move your 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 v3.3?
DMA v3.3 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 are the same, the move to SQL Server 2017 for Linux requires a couple of additional considerations.
Specifying the back-up path
Because Linux and Windows use different path formats, migrating to SQL Server 2017 on Linux requires the user to provide both the Windows and Linux versions of the path to the location of the physical file. This is accomplished in different ways depending on the location of the physical file.
If the physical back-up file is on a computer running:
- Linux, use a ‘samba’ share to share the file with other computers on the network.
- Windows, use the ‘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.
Migrating Windows logins
While the migration of Active Directory (AD) logins is officially supported by SQL Server 2017 on Linux, it requires additional configuration to work successfully. Please refer to the topic Active Directory Authentication with SQL Server on Linux for details on setting up Active Directory logins on SQL Server 2017 on Linux. After this the setup is complete, you can migrate Active Directory logins as usual. Note that standard SQL Authentication will work as expected without any additional set up.
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, and Azure SQL Database.
You can install the tool from Microsoft Download Center. Execute DataMigrationAssistant.msi to install Data Migration Assistant.