Azure DMS migration from SQL Server to Azure SQL Managed Instance

Charles Dove 20

Have a planned migration for SQL Server on Azure Windows VM to a single Azure Managed Instance using the Azure Data Studio interface. This migration has several databases to migrate in "online" mode.

Since, all of the databases are in some form used by clients various services and applications we are using "online" to minimize downtime.

The question is does the DMS service migrate the databases in parallel or serially?

Charles Dove 20 Reputation points

2024-07-25T21:13:59.71+00:00

Oury:

Thanx for the response.

I have one additional question in the FAQ there is an error scenario when trying to migrate more than 4 databases at a time. Is this still true????
Oury Ba-MSFT 18,616 Reputation points Microsoft Employee

2024-07-26T19:31:17.4133333+00:00

Charles Dove

Coud you please point out where it is mentioned that migrating more than 4 databases at a time is causing an error on the doc FAQ.

Regards,

Oury
Charles Dove 20 Reputation points

2024-07-26T20:58:52.2733333+00:00

https://video2.skills-academy.com/en-us/azure/dms/known-issues-troubleshooting-dms#max-number-of-databases-selected-for-migration

Section https://video2.skills-academy.com/en-us/azure/dms/known-issues-troubleshooting-dms#max-number-of-databases-selected-for-migration
Oury Ba-MSFT 18,616 Reputation points Microsoft Employee

2024-07-30T14:57:08.1+00:00

@Charles Dove

DMS does not impose any such restrictions, however it is mostly depending upon the Azure SQL Targets limitations.

You may refer this link: Known issues, limitations, and troubleshooting - Azure Database Migration Service | Microsoft Learn

Above links you shared belong to DMS (classic) which is an older version and does not hold true for DMS. We will update it.

Thanks a lot!

Regards,

Oury

1 answer

Oury Ba-MSFT 18,616 Reputation points Microsoft Employee

2024-07-25T19:42:02.07+00:00

@Charles Dove Thank you for reaching out.

Azure Database Migration Service (DMS) can handle database migrations to an Azure SQL Managed Instance both in parallel and serially, depending on the configuration and the specific migration scenario.

In an online migration, data is continuously replicated from the source to the target, allowing for a more parallel approach to minimize downtime.

see the below doc for more information

https://video2.skills-academy.com/en-us/data-migration/sql-server/managed-instance/database-migration-service?tabs=online-with-extension

https://video2.skills-academy.com/en-us/azure/dms/faq

Regards,

Oury
Please sign in to rate this answer.
Oury Ba-MSFT 18,616 Reputation points Microsoft Employee

2024-07-30T17:07:07.0566667+00:00

@Charles Dove Please don't forget to mark as accept answer if the reply was helpful.

Regards,

Oury
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Azure DMS migration from SQL Server to Azure SQL Managed Instance

1 answer

Your answer