Azure SQL Database
An Azure relational database service.
Based on my understanding, the best way to avoid any impact would be to handle the schema transformation is to have that within a transaction within the database
Best practices to do Azure SQL Database schema swapping without impacting end users
![](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(278.4, 3%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYK%3C/text%3E%3C/svg%3E)
Yerramothu, Krishnaveni
0
Reputation points
We are planning to do the Azure SQL Database schema swapping which is taking <4s but still how to make sure application user is not affected or got surprised by seeing new data.
Azure SQL Database
{count} votes
-
Oury Ba-MSFT 21,146 Reputation points Microsoft Employee Moderator2024-07-31T00:17:22.56+00:00 Have you just migrated to an Azure SQL Database and planning to migrate the schema with minimal downtime.?
Regards,
Oury
-
Oury Ba-MSFT 21,146 Reputation points Microsoft Employee Moderator
2024-08-01T00:11:18.57+00:00 I have not heard back from you yet. Did you had the chance to check the above comment.
Regards,
Oury
Sign in to comment
1 answer
Sort by: Most helpful
-
Nandan Hegde 36,716 Reputation points MVP Volunteer Moderator2024-08-01T05:21:04.2066667+00:00