Forum Discussion
About "dbo_" prefix added during Azure SQL DB Mirroring
Hi everyone!
I have a question regarding the Azure SQL Database mirroring that is available within Fabric. Previously, when I mirrored an Azure SQL database in my fabric workspace, the replicated tables would show up as "dbo_{table_name}" format as follows:
This was a mirrored database instance created in November. But the ones I created after December has no "dbo_" prefix in the created table names:
The only discussion I was able to find regarding that was this one:
This change broke our code on dbt side and we needed to update it.
My question is that did the behavior change for that? Would it change again in future? If it might change, is there any webpage you would recommend to keep the track of upcoming updates for existing artifacts in Fabric?
Thanks in advance for your time!
According to the official Microsoft documentation, the previous behavior of adding the "dbo_" prefix to mirrored table names was actually the intended functionality.
https://support.fabric.microsoft.com/en-ca/blog/mirroring-sql-server-database-to-fabric?ft=All
This was confirmed in a community forum post where it was stated that prepending "dbo_" to table names in mirrored databases was normal behavior , same blog you are referring to :
However, Microsoft has since updated this behavior. Tables created in mirrored databases after December no longer have the "dbo_" prefix, as you observed. This change appears to be part of ongoing improvements to the mirroring feature in Fabric, rather than a bug fix.
For future release please bookmark this page :
https://learn.microsoft.com/en-us/fabric/release-plan/?wt.mc_id=DP-MVP-5004778
https://learn.microsoft.com/en-us/fabric/get-started/whats-new
Please accept this solution , if this is helpful.
ThanksNilendra
2 Replies
According to the official Microsoft documentation, the previous behavior of adding the "dbo_" prefix to mirrored table names was actually the intended functionality.
https://support.fabric.microsoft.com/en-ca/blog/mirroring-sql-server-database-to-fabric?ft=All
This was confirmed in a community forum post where it was stated that prepending "dbo_" to table names in mirrored databases was normal behavior , same blog you are referring to :
However, Microsoft has since updated this behavior. Tables created in mirrored databases after December no longer have the "dbo_" prefix, as you observed. This change appears to be part of ongoing improvements to the mirroring feature in Fabric, rather than a bug fix.
For future release please bookmark this page :
https://learn.microsoft.com/en-us/fabric/release-plan/?wt.mc_id=DP-MVP-5004778
https://learn.microsoft.com/en-us/fabric/get-started/whats-new
Please accept this solution , if this is helpful.
ThanksNilendra
Hi nilendraFabric ,
Thanks for the reply and page suggestions related to future releases. This answers my question.
