Forum Discussion

rd_123's avatar
rd_123
New Member
9 months ago

Fabric Mirrored SQL Server (on prem) does not support VNET data gateway

I would like to create a mirror for an on prem SQL Server database using a VNET data gateway for connectivity (as we have a S2S VPN set up) but this is not currently supported. When trying to create ...
Need Help
V-yubandi-msft's avatar
V-yubandi-msft
Community Support
9 months ago

Hi rd_123 ,

We understand your situation regarding the use of a VNet data gateway with a Site to Site VPN, and that’s a reasonable use case. You might consider submitting this suggestion to the Fabric Ideas - Microsoft Fabric Community  so the product team can review it for future updates.

Thank you for your feedback rd_123 , and thank you for your valuable response, tayloramy 

 

Regards,
Yugandhar.

spaceman127's avatar
spaceman127
Super User
9 months ago

Hi rd_123,

 

You could use a workaround.

Since you already have a connection between Azure and On Premise via VPN, you could use an Azure Managed Instance and connect it to your On Premise SQL Server via Managed Link. Of course, you must first check whether your SQL Server meets the requirements for this.

 

Here is the documentation for this.

https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/managed-instance-link-feature-overview?view=azuresql

 

Then copy the data you need to Fabric using a Copy Pipeline.

Unfortunately, mirroring for SQL Managed Instance is not supported if you use the Managed Link feature.

 

Here are the limitations when using the Managed Link feature.

https://learn.microsoft.com/en-us/fabric/mirroring/azure-sql-managed-instance-limitations

 

This is not ideal, but it would be one option.

 

Best regards