When will Fabric support Mirroring Azure SQL Database support behind an Azure Private Network?

[evergreen1234]

As of today, December 17, 2024, there is a pretty big limitation for using Mirroring for Azure SQL Databases within Microsoft Fabric:

Currently, Mirroring doesn't support Azure SQL Database logical servers behind an Azure Virtual Network or private networking. If you have your Azure Database instance behind a private network, you can't enable Azure SQL Database mirroring.

• Currently, you must update your Azure SQL logical server firewall rules to Allow public network access.
• You must enable the Allow Azure services option to connect to your Azure SQL Database logical server.
• Source: Microsoft Fabric Mirrored Databases From Azure SQL Database - Microsoft Fabric | Microsoft Learn

There's no way I'm going to get CTO support for implementing Mirroring if I need to enable public network access for the primary read-write database (source: Limitations and Behaviors for Fabric Mirrored Databases From Azure SQL Database - Microsoft Fabric |...).

Therefore, when can we expect this feature so that we can plan accordingly?

Thank you!

[Anonymous · Accepted solution]

Hi @evergreen1234 

The current public roadmap doesn't mention the support for mirroring Azure SQL DB behind virtual or private networks. It seems this feature may not be available in the short term. There is a similar idea at Fabric Ideas Forum, you may vote it up via Microsoft Idea: Database mirroring - private network support

Microsoft is always rolling out new features in Fabric, so keep an eye on the official blog for the latest feature updates.

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

[evergreen1234]

Thank you very much, Jing! Hopefully it gets added to the public roadmap as it would save a lot of time to solve the ingestion piece of ELT within Azure.