Skip to content

TechDirectArchive

Hands-on IT, Cloud, Security, Veeam & DevOps

  • Home
  • About
  • Advertise With US
  • Reviews
  • Contact
  • Toggle search form

DMA Compatibility Mode: Prepare and Migrate Safely

Posted on 26/12/202511/09/2026 Link State By Link State No Comments on DMA Compatibility Mode: Prepare and Migrate Safely
  1. Home
  2. Network | Monitoring
  3. DMA Compatibility Mode: Prepare and Migrate Safely
Data Migration Assistant Compatibility mode

In this guide, we will discuss “MSSQL DMA Compatibility Mode: Prepare and Migrate Safely”. In the context of database modernisation and cloud adoption. Assessing compatibility and identifying potential risks are critical steps before any migration activity. Please, see How to Protect Thunderbolt Ports in Windows, how to Migrate Veeam One Database from SQL Server 2017 to 2025, and How to check the version of Windows ADK.

Microsoft Data Migration Assistant (DMA) is a valuable tool designed to support this process by analyzing existing SQL Server instances and highlighting possible issues that may arise when migrating to a newer SQL Server version or to Azure SQL.

DMA provides detailed insights into compatibility gaps, deprecated features, and behavioral changes. This enables organizations to make informed decisions and plan remediation activities in advance.

Microsoft offers the Data Migration Assistant (DMA) as a free tool that users typically install on a separate server to protect production performance. This article explores how the DMA reduces migration risks and increases confidence by detailing its key capabilities and effective implementation strategies.

Ms DMA (Data Migration Assistant)

Here is the official download DMA. The Ms DMA (Data Migration Assistant) tool allows you to analyse existing instances. And check for any critical issues if you want to migrate to a higher version or to Sql Azure.

The tool is free and should preferably be installed on a server separate from the instances.

Then run the setup (a simple wizard). Click Next to proceed

image002-min

Finish installation

image004-min

Launch the application

image006-min

Create a new project and assign it a name.

image008-min

We choose ‘Assessment’ because we want to analyse the source instance without actually performing any migration actions. In this case, the source instance will be a 2008 R2 and the target a 2016. After filling in the fields, select ‘Create’.

image010-min

Set the target instance (2016) and flag as shown in the figure.

image012-min

Set the instance to be analysed and the authentication method. The login that connects to the instance must have the permissions shown in the figure, then select ‘connect’.

image014-min

Select the databases you wish to analyze and then click ‘Add’.

image016-min

Below is a summary, then select ‘Start Assessment’.

image018-min

At the end of the analysis, the graphical report shows the possible issues and suggestions for each database and each compatibility level.

image020-min
image022-min

By selecting ‘Export Report’, you can save the report in csv (not very readable) or json format, which can be read using a json viewer such as https://codebeautify.org/jsonviewer for example.

image024-min

Below is a clear explanation followed by a concise recap, written in a professional and technical tone.

Please, see “Migrate Veeam MSSQL Database to a new Microsoft SQL Server“, how to Install WSL on Windows, and “How to use the Program Compatibility Troubleshooter to Test Application Compatibility on Windows 11“.

Explanation

By using a tree structure, recommendations and analysis results are organized hierarchically, making them easier to explore and interpret.

This approach allows you to start from a high-level overview at the SQL Server instance level and progressively drill down into more detailed insights.

At the database (DB) level, you can identify issues and recommendations that affect an entire database, while at the individual compatibility level, you can focus on specific objects, features, or behaviors within a particular database.

This structured navigation helps isolate risks, understand their scope, and prioritize remediation actions more effectively during a migration or upgrade assessment.

image026-min
image028-min

Recap

  • Tree structure provides a clear, hierarchical view of analysis results
  • Recommendations can be reviewed at instance, database, and object/compatibility level
  • Enables efficient drill-down from high-level findings to detailed issues
  • Simplifies risk assessment and remediation planning for migrations and upgrades

I hope you found this guide very use on “MSSQL DMA Compatibility Mode: Prepare and Migrate Safely”. Please, feel free to leave a comment below.

Thank you for reading this post. Kindly share it with others.

  • Share on X (Opens in new window) X
  • Share on Reddit (Opens in new window) Reddit
  • Share on LinkedIn (Opens in new window) LinkedIn
  • Share on Facebook (Opens in new window) Facebook
  • Share on Pinterest (Opens in new window) Pinterest
  • Share on Tumblr (Opens in new window) Tumblr
  • Share on Telegram (Opens in new window) Telegram
  • Share on WhatsApp (Opens in new window) WhatsApp
  • Share on Mastodon (Opens in new window) Mastodon
  • Share on Bluesky (Opens in new window) Bluesky
Network | Monitoring

Post navigation

Previous Post: Preliminary Guide for WSUS Analysis and Initial Assessment
Next Post: Testing Disk Subsystem Integrity for SQL Server with SQLIOSim

Related Posts

  • Featured image wifipass
    Find saved Wi-Fi Passwords in Windows 10 and 11 Network | Monitoring
  • maxresdefault 2 3
    How to configure WatchGuard WebCenter Network | Monitoring
  • Telegram
    Integrate a WordPress site with WP Telegram Network | Monitoring
  • Reverse Image Search
    How to Perform a Reverse Image Search on Your Browsers Network | Monitoring
  • Fix Windows Security Blank Screen Issue
    How to Fix Windows Security Blank Screen Issue Network | Monitoring
  • images 2
    AnyConnect SSL VPN Client Configuration Guide Network | Monitoring

More Related Articles

images 2 AnyConnect SSL VPN Client Configuration Guide Network | Monitoring
How to Fix Microsoft Edge Not Responding on Windows 11 How to Fix Microsoft Edge Not Responding on Windows 11 Network | Monitoring
maxresdefault 2 3 How to configure WatchGuard WebCenter Network | Monitoring
SQLIOSim utility to simulate SQL Server Testing Disk Subsystem Integrity for SQL Server with SQLIOSim Network | Monitoring
create Microsoft 365 Account How to create Microsoft 365 Account Network | Monitoring
Watchguard Firewall 180504 100511 WatchGuard Log and Report Server Installation in a VM Network | Monitoring

Leave a Reply Cancel reply

You must be logged in to post a comment.

Microsoft MVP

vexpert-badge-stars-5

Virtual Background

VEEAMLEGEND

Categories

Top 30 Sysadmin blog

veeaam100

Veeam Vanguard

  • vcenter sign on
    CVE-2021-22048: VMware vCenter Server updates address a privilege escalation vulnerability Security | Vulnerability Scans and Assessment
  • ffd
    Unable to bind to LDAP or AD in Pleasant Password Server Password Manager
  • windows10update 1
    License file was not found in the specified path (Error 0xc1570103) Windows Server
  • addanewlang
    How to change or add another keyboard language in Windows Server Windows Server
  • windows 10 keyboard shortcut 1024x512 1
    How to create a Desktop shortcut in Windows Windows
  • Screenshot 2020 05 13 at 19.23.25
    AWS Command-Line Interface: How to configure AWS CLI [Part 1] AWS/Azure/OpenShift
  • remote desktop connection tabs rdp tabs
    Guide to Remote Desktop Connection Properties for Secure Access Windows
  • Database Collation
    Change SQL Database Collation: ePO events DB and SQL server should match with ePO core collation Oracle/MSSQL/MySQL

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 1,746 other subscribers
  • RSS - Posts
  • RSS - Comments
  • About
  • Authors
  • Write for us
  • Contact
  • Advertise with us
  • General Terms and Conditions
  • Privacy policy
  • Feedly
  • Telegram
  • Youtube
  • Facebook
  • Instagram
  • LinkedIn
  • Tumblr
  • Pinterest
  • Twitter
  • mastodon
  • Bsky

Tags

Active Directory Azure Bitlocker Microsoft Windows PowerShell WDS Windows 10 Windows 11 Windows Deployment Services Windows Server 2016

Copyright © 2026 TechDirectArchive

Loading Comments...

You must be logged in to post a comment.