SQL Server Performance

Snapshot Repl

Discussion in 'SQL Server 2005 Replication' started by xiebo2010cx, Feb 10, 2007.

  1. xiebo2010cx Member

    It seems not possible to achieve snapshot repl with updatable subscribers using the Repl Wizard?
    Does this mean we have to use sp code to do this?




    ------------------
    Bug explorer/finder/seeker/locator
    ------------------
  2. MohammedU New Member

    I don't think there is any updatable subscribers in snapshot replication...

    Are you talking about Transactional replication?

    MohammedU.
    Moderator
    SQL-Server-Performance.com
  3. xiebo2010cx Member

    Mohammed, I am pretty sure, with Snapshot Repl, we also can setup with updatable subscribers.

    SQL Server using the trigger to achieve the updatable subscribers, when trigger-able change happens on Subscriber, the trigger fires and commit the change to both subscriber and publisher, or queued the changes, later propagate to the publisher.

    But from the Repl Wizard, this feature does not appear

    ------------------
    Bug explorer/finder/seeker/locator
    ------------------
  4. MohammedU New Member

    May be you are looking for transactional replication with immemdiate updating subscriptions...


    MohammedU.
    Moderator
    SQL-Server-Performance.com

Share This Page