Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Author
Message
Posted Thursday, June 13, 2013 1:23 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 1:58 AM
Points: 431, Visits: 1,003
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?

Thanks


=============================================================
Atif Shehzad
DBA
Zin Technologies
Post #1463279
Posted Saturday, June 15, 2013 10:29 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, October 3, 2014 1:55 PM
Points: 199, Visits: 735
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