Forum Discussion

ClinDev's avatar
ClinDev
Regular Visitor
1 year ago
Solved

Mirror SQL Azure via readonly replica

Hello  We are using a Premium tier P1 SQL Azure database, so we have a readonly replica. When we try to mirror that in Fabric, the connection string window has no option to put the connectionstring....
Need Help
ClinDev's avatar
ClinDev
Regular Visitor
1 year ago

Hi


Thank you for that, but I meant how do I point to that readonly replicae in microsoft Fabric? As I showed in the screenshot above, there is no option in the UI in Fabric when connecting to SQL azure to point to readonly. 

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi ClinDev ,

 

It's currently a preview version, and may not have connection types, but try making the connection. Connections are listed in the documentation for reference:

Tutorial: Configure Microsoft Fabric mirrored databases from Azure SQL Database (Preview) - Microsoft Fabric | Microsoft Learn

 

For more questions about mirroring SQL Azure you can refer to:
Frequently asked questions for Mirroring Azure SQL Database in Microsoft Fabric (Preview) - Microsoft Fabric | Microsoft Learn

 

Hope it helps!

 

Best regards,
Community Support Team_ Scott Chang

 

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.