Data Migration Assistant (DMA) to check SQL server compatibility issues for migrating one version to higher version

Disclaimer:Hey Guys, this post contains affiliate link to help our reader to buy best product\service for them. It helps us because we receive compensation for our time and expenses.


Well, it is always a good practice to use DMA tool by Microsoft to check any compatibility issues before upgrading to higher version of SQL server.

Being a DBA, it is one of the recommended steps to be followed before upgrading to higher version of your SQL server.

This assistant tool provided by Microsoft helps to cover below important points.

  • Discovery of issues that can affect an upgrade to an on-premises version of SQL Server. Any findings are described as compatibility issues, and they’re categorized into the following areas:
    • Breaking changes
    • Behavior changes
    • Deprecated features
  • Discovery of new features in the target SQL Server platform that the database can benefit from after an upgrade. Any findings are described as feature recommendations, and they’re categorized into the following areas:
    • Performance
    • Security
    • Storage
  • Modern user experience to perform assessments.





Overall summary:-

Data Migration Assistant (DMA) enables you to upgrade to a modern data platform by detecting compatibility issues that can impact database functionality on your new version of SQL Server. It recommends performance and reliability improvements for your target environment. It allows you to not only move your schema and data, but also uncontained objects from your source server to your target server.

You can download the latest version of DMA from Microsoft link here.

Now ,lets see the installation of Data Migration Assistant(DMA) post download.

> Click to install Windows Installer setup file for DMA

> Click Next

>Accept the License.

>Click Install

InterServer Web Hosting and VPS

>Once Install,open this Data Migration Assessment tool.

>Click on create new Assessment/Migration and fill the required fields.

>Select the required destination SQL version for which you want to do this assessment.

Select the report type from the checkbox below


Connect to Source server which you want to be upgraded

>Add the available database

>Click on Start Assessment.

It will take time to run the assessment depending on databases and its size and you can export the result .

Hope this helps!



The biggest guru-mantra is: never share your secrets with anybody. It will destroy you.