Snapshot Repl | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Snapshot Repl

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
——————
I don’t think there is any updatable subscribers in snapshot replication… Are you talking about Transactional replication? MohammedU.
Moderator
SQL-Server-Performance.com
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
——————
May be you are looking for transactional replication with immemdiate updating subscriptions…
MohammedU.
Moderator
SQL-Server-Performance.com
]]>