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 (12)

  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

    Abhishek

  6. prashant says:

    What is the best practice. Should we fix the issues on Source or need to migrate to destination server and then fix it

    1. Harini Gupta says:

      Hi Prashant,

      Thanks for reaching out to us and thank for using DMA. Our recommendation is to fix issues after moving to target so there is none to minimal impact on source server. There could be exceptions in the case if Azure Database migrations where you will not be able to move your objects until the migration blockers have been addressed in the source.

      Hope this helps.

  7. Alex says:

    We installed DMA (v3.1) on a Server 2012 R2 server that does not have access to the internet. DMA is able to see the databases to be assessed on another server (also Server 2012 R2. The assessment starts but never completes. Does DMA require access to the internet?

    1. Harini Gupta says:

      Hi Alex,

      Thanks for reaching out to us. In the context that you are describing, it is not required for DMA to have internet access. There must be something else going on with assessments that it’s not completed. Can you share the DMA logs with us via email to dmafeedback@microsoft.com? DMA logs can be located here:
      %AppData%\Local\DataMigrationAssistant\Dma.log
      %AppData%\Local\DataMigrationAssistant\DmaError.log

Skip to main content