Share via

Azure DMS migration from SQL Server to Azure SQL Managed Instance

Charles Dove 20 Reputation points
2024-07-25T13:59:45.3733333+00:00

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?

Azure Database Migration service

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Oury Ba-MSFT 21,156 Reputation points Microsoft Employee Moderator
    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://learn.microsoft.com/en-us/data-migration/sql-server/managed-instance/database-migration-service?tabs=online-with-extension

    https://learn.microsoft.com/en-us/azure/dms/faq

    Regards,

    Oury

    Was this answer helpful?

    1 person found this answer helpful.

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.