Time to dive into Microsoft Data Migration Assistant. In this part of the DMZ log series, we’ll take a look at how we install DMA.

Previous Post –

Check out part 1 of this blog series – Preparing to Upgrade SQL Server? Data Migration Assistant! Part 1 #MVPHour #SQLServer #DMA

Download a Copy of Microsoft Data Migration Assistant

As of this blog post, the current version of Microsoft Data Migration Assistant is version 3.1. You can get a copy of it from here – https://www.microsoft.com/en-us/download/details.aspx?id=53595

If you want to check for a newer copy, try searching for “Microsoft Data Migration Assistant” on the Microsoft Download Center (https://www.microsoft.com/en-us/search/result.aspx?q=microsoft+data+migration+assistant&search).



  • 64-Bit Operating System
    • Windows 10, Windows 8.x, Windows 7 and Windows Server 2012
  • .NET Framework 4.5

GUI Install

This is a traditional, but simple install of next, next, finish. Below are the screens that you’re presented with.








Silent Install

This is a very straight forward MSI. When I took a quick look at the install log, the following properties are available:

  • INSTALLFOLDER = C:\Program Files\Microsoft Data Migration Assistant\

The product code for this installer is {6B6D5D5C-4955-4FA9-9C74-E31C24BEAA55}.

Command line Example 1 –

Start /w msiexec /i “DataMigrationAssistant (1).msi” /qn /l* c:\temp\dma.log


Command line Example 2 –

Start /w msiexec /i “DataMigrationAssistant (1).msi” /qn /l* c:\temp\dma.log INSTALLFOLDER=E:\DMA