Post reply

To create updatable subscription in single side replication

  • June 13, 2013 at 1:23 pm

    #394962

    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

    DBDigger Microsoft Data Platform Consultancy.

  • June 15, 2013 at 10:29 am

    #1624367

    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.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply