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).
Installation
Requirements
-
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
