Do I need to turn-off or stop the database server during the execution of dms migration?

Khristian Dave Poleracio 131 Reputation points
2023-01-25T06:52:48.3233333+00:00

I am planning to migrate from single server to flexible database server.

Azure Database Migration service
0 comments No comments
{count} votes

Accepted answer
  1. ShaktiSingh-MSFT 12,386 Reputation points Microsoft Employee
    2023-01-25T13:40:10.12+00:00

    Hi @Khristian Dave Poleracio ,

    Thanks for posting this question in Microsoft Q&A forum.

    As I understand from question, you want to understand if during Migration of Single to Flexible Azure DB for MySQL, will there be downtime.

    Please correct if my understanding is different.

    Azure Database Migration Service supports both offline and online migrations. With an offline migration, application downtime starts when the migration starts. With an online migration, downtime is limited to the time required to cut over at the end of migration. We suggest that you test an offline migration to determine whether the downtime is acceptable; if not, then perform an online migration. Online and Offline migrations are compared in the following table:

    User's image

    Please go through the Migration steps, Limitations and Best practices before going for actual migrations: [https://learn.microsoft.com/en-us/azure/dms/tutorial-mysql-azure-single-to-flex-online-portal

    Hope this helps. If you have further queries do let us know. Thanks

    0 comments No comments

0 additional answers

Sort by: Most helpful