Azure Database Migration service
An Azure service designed to help simplify, guide, and automate database migrations to Azure.
Azure SQL Server Offline Database Migration via self-hosted impact on source server question
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(316.8, 15%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWB%3C/text%3E%3C/svg%3E)
William Bartley
0
Reputation points
I'm running 5 databases on my production on prem SQL server in the same instance. If I run the offline migration targeting only 1 of those databases, do the other 4 databases stay online during the migration?
I don't see in the Q&A Assist's answer where it specifically calls out only the migrated database is impacted.
Azure Database Migration service
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(166.4, 95%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESD%3C/text%3E%3C/svg%3E)
Saraswathi Devadula 16,025 Reputation points Microsoft External Staff Moderator2025-04-02T16:51:23.6366667+00:00 Hello William Bartley
Greetings!
I understand that you want to migrate one of the databases in the Onprem SQL server and want to know if the databases on the server will remain online during the migration.
Please be informed that if you perform the migration targeting only one of the databases on your production Onprem SQL Server, the other databases will stay online during the migration process. The application downtime will only affect the database being migrated.
I hope this information is helpful. Please let me know if you have any further concerns. I am happy to address your queries.
-
William Bartley 0 Reputation points
2025-04-02T18:10:18.7+00:00 Thank you Saraswathi, I couldn't find that explicitly documented.
-
Saraswathi Devadula 16,025 Reputation points Microsoft External Staff Moderator
2025-04-03T03:05:50.1+00:00 Hello William Bartley
Greetings!
Kindly request you to please share the details requested over the private message for further investigation.
-
Saraswathi Devadula 16,025 Reputation points Microsoft External Staff Moderator
2025-04-04T11:16:27.37+00:00 Hello William Bartley
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Sign in to comment
Sign in to answer