Released: Data Migration Assistant (DMA) v1.0


Overview

Data Migration Assistant (DMA) delivers scenarios that reduce the effort to upgrade to a modern data platform by detecting compatibility issues that can impact database functionality after an upgrade. It recommends performance and reliability improvements for your target environment.
DMA replaces SQL Server Upgrade Advisor.

What is new?

  • 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
  • Discovery of 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
  • Modern user experience to perform assessments.

Installation

You can install the tool from Microsoft Download Center. Execute sqladvisor.msi to install Data Migration Assistant.

Resources

Data Migration Assistant: How to assess your on-premises SQL Server

Data Migration Assistant: Known Issues

Data Migration Assistant: Best Practices

Comments (6)

  1. Bill Ramos says:

    Any idea where there will be a update that will help perform the upgrade like the prior version that released back in February?

    1. Hello,
      In our next release we are planning to enable the migration of schema, data and server logins from on-premises SQL Server to modern versions of on-premises SQL Server and SQL Server on Azure VMs as long as Azure VMs are accessible from on-premises network.
      Please let us know if you are suggesting any other upgrade/migration scenarios that you want to see in DMA.
      Thanks
      Raj

  2. Krati S says:

    A great product which combines upgrade, migration and modernization. The DMA UI and intelligence to gather DB compatibility levels, size, identifying breaking, behavioral changes, feature recommendation is great but there are few aspects in user interface which seemed like stuck. For example, on Assessments page, if by mistake New Project type button is clicked, it does not hide the “New Project screen” and there is no close button. The UI becomes cluttered and does not allow to go back to Assessments page. This cluttered interface will not go away till DMA is closed. Shared this in DMA Feedback page. Another observation was there is no way to import or see an exported assessment report. Is there a way to see the exported report in tool?

    1. Hello Krati,
      Thank you for your feedback. You can export the assessment results by clicking “Export report” button on “Review results screen”, you can see this button on the bottom-right. This will let you save the assessment results into CSV format. Please let us know if that is not what you are looking for.
      Thanks
      Raj

  3. Mike says:

    Hi,
    Where is the functionality to test if DBs are compatible with Azure SQL?
    If this has been removed then the 2016 Advisor should still be made available, rather than replacing.
    Thanks,
    Mike

    1. The assessments for migrating to Azure SQL database through DMA is open for private previews. Please let me know if you are interested, I can add you into our private preview program. This feature will be released for GA towards end of JAN 2017.
      Thanks
      Raj

Skip to main content