0

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.

1

Is it possible to configure replicaiton ?

Yes.

if so, is there any way to open connection only unidirectional , from production domain to VLAN ?

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.

  • ok thanks David. so if Distribution database is in publisher instance, then we need to open ports between both servers, right ? – Robin16 Aug 21 '17 at 17:47
  • You wouldn't need an inbound firewall rule on the Publisher/Distributor as the connections would all be outbound to the Subscriber. – David Browne - Microsoft Aug 21 '17 at 17:49
  • thanks again...so distributor doesn't wait for ack or message from subscriber once the records are transferred to subscriber ? – Robin16 Aug 21 '17 at 17:52
  • Yes. The Distributor will open a TCP/IP connection to the Subscriber and use TDS to communicate. It's normal SQL Server client connectivity from the Distributor to the Subscriber, and definitely requires IP packets to travel both ways between the Subscriber and the Distributor over the established TCP/IP connection. – David Browne - Microsoft Aug 21 '17 at 17:55
  • Thanks again for your prompt response....sorry for so many questions it's kind of confusing to me....when you say, "It's normal SQL Server client connectivity from the Distributor to the Subscriber, and definitely requires IP packets to travel both ways between the Subscriber and the Distributor over the established TCP/IP connection." so does it work if i open port 1433 of VLAN in production domain ? or do i have to open port 1433 in VLAN as well ? – Robin16 Aug 21 '17 at 18:08

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.