Cross DB query between Azure SQL Server VM on Azure Gov Cloud and Azure Public cloud

Question

I have an on-premises database which communicates with Azure SQL Sever VM on public cloud using linked server. Now we have a requirement to move the on-prem db to Azure Government Cloud.

After migration to Azure Gov cloud how can I maintain the connection for cross db query between SQL servers on Gov cloud and Public cloud? My understanding is Global vnet peering cannot be maintained between Gov cloud and on-prem cloud.

Is there a way to keep the functionality of cross DB query intact after migration?

Answer 1

One way to solve this would be to move the Azure SQL Sever VM on public cloud to the Azure Gov cloud. When they are both in the same cloud it is possible to do cross server queries.

Since the data on the 2 servers are related, it may be that both belong in the Gov cloud.

Answer 2

While you will not be able to use Global VNET peering between Public & Government clouds, you can use Azure Virtual Network Gateways to establish a VPN between the two clouds. If that is not an option for you, you can configure public IP endpoints for your SQL Servers on both ends. With this option will definitely want to establish firewalls or NSG rules to restrict any other outside traffic.