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.

Scenario:-

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.

Click to purchase any products from Amazon with an attractive price and offers!

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