Data Migration Assistant: FAQs

This page addresses all the frequently asked questions.

1. What is the difference between Upgrade Advisor (UA) and Data Migration Assistant (DMA)?

All versions of UA are officially deprecated and have been replaced by DMA for your migration needs. The core differences between the tools are as follows:

  • UA performs only assessments, DMA enable you to perform assessments and as well as migrations.  DMA provides E2E migration experience.
  • UA only provides assessments migrating to on-premises SQL targets, but DMA extends to Azure Database platforms as well.
  • You need to have a specific UA tool, per each target SQL Server version, but DMA is a unique tool and supports all target SQL versions, starting SQL Server 2012.
  • UA enables assess the workload traces, but DMA only assess the schema and static objects.
  • All versions of UA is officially deprecated and replaced by DMA.


Comments (8)

  1. Abhishek says:

    Hi Harini,

    Can u please update that DMA supports SQL Data warehouse analysis and upgrade?
    Also is DMA able to analyze DataMarts, Cubes, FACT tables?

    1. Harini Gupta says:

      Hi Abhishek,
      Thanks for reaching out. DMA currently doesn't support analysis for SQL DW, Datamarts, Cubes, and FACT tables. Sorry about the inconvenience.

  2. Abhishek says:

    Hi Harini,
    Does upgrade advisor analyze data warehouse?

    1. Harini Gupta says:

      SSUA never supported SQL DW as upgrade target. SSUA has been deprecated and replaced by DMA.

  3. Abhishek says:

    Hi Harini,
    Where will be breaking changes fix? Target Sql instance or Source.

  4. Vijayakumar N says:

    Will DMA assess all SQL server components like SQL Database engine, Analysis services, report services, integration services for compatibility issues and suggest recommendations?

    1. Harini Gupta says:

      Currently, DMS assesses DB engine only.

  5. Abhishek says:

    Hi Harini,
    Have few questions about DMA, please answer
    a. What are the min privileges needed for the a/c used in DMA in order to run the assessment and migration
    b. DMA performance benchmarks.
    c. Productivity improvements achieved using DMA
    d. Will it allow to DB object level selection


Skip to main content