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

Question

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

Answer 1

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:

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