Legacy Update: Get back online, activate, and install updates on your legacy Windows PC

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.

• What is new in V5.2?
  
  • This release of DMA adds support for:
    • Uploading assessments to Azure Migrate with support for Azure Government and National clouds
    • Command line support for uploading assessments to Azure Migrate with support for Azure Government and National clouds
    • and bug fixes to address issues during upload to Azure Migrate, SKU recommendations and accessibility for certain controls
  Existing DMA Features
  
  • Assess on-premises SQL Server instance(s) migrating to Azure SQL database(s). The assessment workflow helps you to detect the following issues that can affect Azure SQL database migration and provides detailed guidance on how to resolve them.
    
    
    • Migration blocking issues: DMA discovers the compatibility issues that block migrating on-prem SQL Server database(s)s to Azure SQL Database(s). It then provides recommendations to help customers remediate those issues.
    
    
    • Partially or unsupported features: DMA detects partially or unsupported features that are currently in use at the source SQL Server. It then provides comprehensive set of recommendations, alternative approaches available in Azure and mitigating steps so that customers can plan ahead this effort into their migration projects.
  
  
  • Migrate on-premises SQL Server instance to a modern SQL Server instance hosted on-premises or on an Azure Virtual Machine accessible from your on-premises network (via Azure VPN or ExpressRoute).
    
    The migration workflow helps you to migrate the following components.
    
    
    • Schema of databases
    • Data and Users
    • Server roles
    • SQL and Windows logins
    
    After a successful migration, applications will be able to connect to the target SQL server databases seamlessly.
  
  
  • Discovery of issues that can affect an upgrade to an on-premises SQL Server. These are described as compatibility issues categorized under these areas:
    
    
    • Breaking changes
    • Behavior changes
    • Deprecated features
    
    
  
  
  • Discover new features in the target SQL Server platform that the database can benefit from after an upgrade. These are described as feature recommendations and are categorized under these areas:
    
    
    • Performance
    • Security
    • Storage
    
    
  
  
  • Assess databases at scale in an un-attended mode using dmacmd.exe utility. For details on how to use dmaccmd.exe please refer to Data Migration Assistant: How to run from command line
  
  
  • Automatically detects and suggests fixes for three classes of migration problems - non-ANSI style joins, order by ordinal and sql raiserror statements. These fixes can be ignored or automatically accepted and applieds on a per-object basis.
  
  
  • This feature recommends the minimum Azure SQL Database SKU you should pick for your database based on performance counters collected from the computer(s) hosting your databases. This feature provides recommendations related to pricing tier, compute level, and max data size, as well as estimated cost per month. It also offers the ability to provision all your databases to Azure in bulk through a HTML page. Note that this functionality is available only via the Command Line Interface (CLI).
  
  
  • Assessment support for migrating on-premises SQL Server databases to Azure SQL Database Managed Instance. Customers can now use DMA to assess SQL Server on-premises or use a provided PowerShell script to collect metadata about their database schema, detect the blockers, and partially supported or unsupported features that affect migration to Azure SQL Database Managed Instance and to gain detailed guidance on how to resolve the issues after the migration.
  
  
  • Command line support for target readiness assessment for one more server instances when migrating from on-premises SQL Server to Azure SQL Database Managed Instance. Customers can now use DMA command line to collect metadata about their database schema, detect the blockers, and partially supported or unsupported features that affect migration to Azure SQL Database Managed Instance. The results can then be rendered using the Power BI template provided.
  
  
  • DMA now enables uploading assessments to Azure Migrate service.
  
  
  • Assessment activity for migrating SQL Server Integration Services (SSIS) packages to Azure SQL DB and Azure SQL DB Managed Instance
  
  
  • This release of DMA adds support for SQL Server 2019 for Windows and SQL Server 2019 for Linux as targets for assessment; Save and Load Assessments; Application queries as json inputs and more.
  
  
  • This release of DMA adds support for:
    • Command line support for uploading assessments to Azure Migrate including upload existing assessments from a specific folder
    • Configuration file for assessments run from command line
    • SQL Server 2019 as a source for assessments
    • sql_batch_completed event for application / xevent trace assessments
    • and bug fixes to address issues during upload to Azure Migrate, SKU recommendations and accessibility for certain controls
  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 and, RDS SQL Server
  • Target: SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017, SQL Server 2019, Azure SQL Database, Azure SQL Database Managed Instance

Files

Status: Live This download is still available on microsoft.com. The downloads below will come directly from the Microsoft Download Center.

File	SHA1 Hash	Size
DataMigrationAssistant.msi	5a144ee91b5c6e3318d586126d886efe11872f61	18.35 MB

File sizes and hashes are retrieved from the Wayback Machine’s indexes. They may not match the latest versions of files hosted on Microsoft servers.

• Windows 7 64-bit (or Windows Server 2012) and above
  .NET Framework 4.7.2 64-bit or above
  

• Download and run the DataMigrationAssistant.msi package.