Exercise: Install the Data Migration Assistant (DMA)

  • 3 minutes

In your law firm, you need to upgrade several CRM databases used by different teams to SQL Server 2019. These databases include versions from SQL Server 2008 R2 through to SQL Server 2016. You've chosen the Microsoft Data Migration Assistant (DMA) to help with these upgrades.

In this exercise, you'll install the Data Migration Assistant.

Note

Before beginning this exercise, you must complete the Prepare for the exercises steps in the unit Decide if the Data Migration Assistant (DMA) is right for your task.

Download the RDP connection file from Azure

  1. Sign in to the Azure portal using the same account you used to activate the sandbox.
  2. In the portal menu, select Virtual Machines.
  3. In the list, select SQL2019Server.
  4. On the Overview page, at the top, select Connect.
  5. In the drop-down menu, select RDP.
  6. Select Download RDP File, then open it after it's downloaded.

Connect to the SQL Server

  1. In the Remote Desktop Connection dialog box, select Connect.
  2. In the Windows Security dialog box, select More choices, and then select Use a different account.
  3. Sign in with the username azureadmin, and the admin password you used when you created the original virtual machine.

    Note

    You can use the echo $PASSWORD command in the Cloud Shell to show you the password.

  4. In the Remote Desktop Connection dialog box, select Yes to continue.
  5. You should be logged on to the VM.
  6. In the Server Manager window, on the left, select Local Server.
  7. Select On next to IE Enhanced Security Configuration.
  8. In the Internet Explorer Enhanced Security Configuration window, select Off for both Administrators and Users.
  9. Select OK.

Download and restore your company's database

  1. On the task bar, select Internet Explorer.

  2. If the Set up Internet Explorer 11 dialog box appears, select Use recommended security, privacy, and compatibility settings, and then select OK.

  3. In the address bar type
    https://github.com/microsoft/sql-server-samples/releases/download/adventureworks2008r2/adventure-works-2008r2-oltp.bak, then press Enter.

  4. On the pop-up menu, select Save As, select the Windows (C:) drive on the left, and then select Save.

  5. On the Start menu, type cmd, and select Command Prompt.

  6. Execute this command to restore the downloaded backup.

    SqlCmd -E -S SQL2019Server –Q "RESTORE DATABASE [AdventureWorks2008R2] FROM  DISK = N'C:\adventure-works-2008r2-oltp.bak' WITH  FILE = 1,  MOVE N'AdventureWorks2008R2_Data' TO N'C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\AdventureWorks2008r2.mdf',  MOVE N'AdventureWorks2008R2_Log' TO N'C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\AdventureWorks2008R2_log.LDF'"

Download the Data Migration Assistant

  1. Go to the https://github.com/MicrosoftDocs/mslearn-assess-convert-sql-server-databases-using-dma-samples/blob/main/DataMigrationAssistant5.3.msi, then select Download.
  2. On the pop-up menu, select Save.

Install the Data Migration Assistant

Continue by using the installer to set up the Data Migration Assistant.

  1. Using File Explorer, go to C:\Users\azureadmin\Downloads.
  2. Double-click DataMigrationAssistant5.3.msi.
  3. In the Microsoft Data Migration Assistant Setup window, on the Welcome to the Microsoft Data Migration Assistant Setup Wizard page, select Next.
  4. On the End-User License Agreement page, read the terms shown. If you agree to these terms, select the I accept the terms in the License Agreement check box, and then select Next.
  5. On the Privacy Statement page, select Install.
  6. When the installation has finished, on the Completed the Microsoft Data Migration Assistant Setup Wizard page, select the Launch Microsoft Data Migration Assistant check box, and then select Finish. The Data Migration Assistant launches.

Warning

Do not deactivate the sandbox. This sandbox will continue to be used in the next unit.