Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

To create updatable subscription in single side replication Expand / Collapse
Posted Thursday, June 13, 2013 1:23 PM



Group: General Forum Members
Last Login: Monday, April 4, 2016 1:44 AM
Points: 434, Visits: 1,138
Suppose i have to replicate a table from production to reporting server. Production is publisher and report server is subscriber. It is also required that table data may be updated at subscriber. However updates on subscriber should not be send back to publisher. Is it possible to configure such a setting for replication?


Atif Shehzad
Zin Technologies
Post #1463279
Posted Saturday, June 15, 2013 10:29 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, November 21, 2016 5:59 AM
Points: 202, Visits: 776
I think you want to use transactional replication. In this case the replication only works in 1 direction (publisher to subscriber) unless you explicitly configure bidirectional replication.

Post #1463875
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse