Sql connections connectors / 2 networks
-
Hello I need some advice... Let's have two network : Nprod and Ndev. The production server is on Nprod and is connected to 80 customers databases through 80 VPN, all is fine here. But... we need also to connect the Ndev network to the customers databases, for easy (and sometimes emergency) debugging. Sometimes we have a VPN between Ndev and away DBs, sometimes not, and in this case we have to connect to a remote desktop on the Nprod network, open a connection server, pass queries one by one, and try to understand what's going wrong X| = not very convenient and lost of times to react to the bug. So my question is : Is there a way to connect my dev desktop to the Nprod, and then using the VPNs Nprod <-> Customers DB, something like a connector installed on the Nprod network which could pass queries and return results to my dev network ? I don't know where and what to search so if you have some tips or tricks to orient my search, it should be great :)