Legacy Update: Get back online, activate, and install updates on your legacy Windows PC

Data Migration Assistant (DMA) is retired and is no longer available to download. See details section for alternatives for your migration and upgrade needs.

1. Upgrading your SQL Servers to a higher version: Use the Migration component in SSMS
   • How-To Get Started:
     • Install the latest SQL Server Management Studio with Hybrid and Migration workload option.
     • Right click on the SQL Server instance in the Object Explorer and navigate to Migrate SQL Server.
   • Documentation:
     • SSMS Migration Component Guide
     • General Availability Announcement
   
   
2. Migration to Azure SQL:
   
   
   1. Use Azure Data Studio with the SQL Migration extension for GUI-based interactive cloud migration
      • How-To Get Started:
        • Install Azure Data Studio and enable Azure SQL Migration extension
        • Right click on the SQL Server instance and choose Manage.
        • Under Azure SQL Migration, click Migrate to Azure SQL.
      • Documentation:
        • Azure SQL Migration Extension Overview
        • Step-by-Step Assessment using Azure Data Studio
        • Step-by-Step Migration using Azure Data Studio
      
      
   2. Automate with Azure DMS using Azure PowerShell or Azure CLI for command-line automation
      • How-To Get Started:
        • Download and modify the sample the scripts and customize to your requirements : Azure PowerShell / Azure CLI
      • Documentation:
        • Automate Migration with PowerShell/CLI
        • Azure CLI Reference for az datamigration extension
        • Azure PowerShell Reference for Az.DataMigration Module
      
      

Files

Status: Live This download is still available on microsoft.com. The downloads below will come directly from the Microsoft Download Center.

Files
DataMigrationAssistant.msi SHA1: 2c0f0c386cedb3e2710db53cde7775c7e8a70b9b Size: 15.02 MB

 - 

• Version Upgrade: Use SQL Server Management Studio (SSMS) with migration component for assessments and migration of databases to a new SQL Server version running on-premises or on Azure Virtual Machines.


• Migration to Azure SQL:
  • Use automation with Azure Database Migration Service using Azure PowerShell or Azure CLI for command-line assessment and migration
  • Use Azure Data Studio with Azure SQL Migration extension for GUI-based interactive assessment and migration.