Routing Service for SQL Database / TDS RRS feed

  • Question

  • Hi,

    Although it would seem the question is related to Azure SQL Database, the solution I have in mind is related to WCF.
    The problem is simple as that: my client needs to connect from on-prem to Azure SQL Database, but does not allow opening outbound ports such as 1433; in exchange he is ok for setting a VPN-based solution.

    As SQL Azure doesn't allow connecting via fixed IP/VPN tunneling/..., I have in mind to create a VLAN in Azure, connect from on-prem via VPN, deploy a WCF Routing Service in Azure VLAN, and route calls from on-prem to SQL Azure via that Routing Service.

    If theoretically it sounds feasible, I don't really get how to transit SQL/TDS data stream through a WCF service. Do you have an idea if it is possible, and how to do that?

    Thanks in advance,


    Monday, June 10, 2013 10:21 PM


All replies