question

Vishu-2318 avatar image
0 Votes"
Vishu-2318 asked Cathyji-msft commented

DB Migration

Experts, Can you please suggest some tools - Preferably native by MS which would help analyze for DB migration

  1. if DB is compatible from a specific version to a specific version

  2. Based on the current utilization of the source instance if the databases can be migrated to the destination and what CPU/RAM/IOPS would it utilize





sql-server-general
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @Vishu-2318,

We have not received a response from you. Did the replies could help you? If the response helped, do "Accept Answer". If it is not, please let us know. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

0 Votes 0 ·
Cathyji-msft avatar image
0 Votes"
Cathyji-msft answered

Hi @Vishu-2318,

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

Database Experimentation Assistant (DEA) is an experimentation solution for SQL Server upgrades. DEA can help you evaluate a targeted version of SQL Server for a specific workload. Compare workloads between source and target SQL Server

Refer to the MS document Compare SQL data migration tools.


If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ErlandSommarskog avatar image
0 Votes"
ErlandSommarskog answered

For the first part you can use DMA, the Database Migration Assistent. I have not used DMA myself, but I would not expect that it handles the second part of the question. It sounds like something you would have to turn to a third-party tool. You may be interested in looking at SQL Governor.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.