I have a requirement to replicate data between two sql server 2014 instances, one of the instance is in our production domain and second instance is in a separate VLAN.
Is it possible to configure replicaiton ? if so, is there any way to open connection only unidirectional , from production domain to VLAN ? does it require bidirectional network connection like subscriber (here sql instance in VLAN) should also need access to publisher (here production domain) ?
thanks in advance.
Best Answer
Yes.
Packet-flow must, of course, work in both directions. If the Distributor can connect to both the Publisher and Subscriber, you can use Push Subscriptions. With a Push Subscription all the processes run on the Distributor, and the Subscriber would never need to connect to the Publisher or Distributor.