Contents
Do you have to be connected to update data at the subscriber?
The Publisher and Subscriber must be connected to update data at the Subscriber. Queued updating The Publisher and Subscriber do not have to be connected to update data at the Subscriber. Updates can be made while the Subscriber or Publisher is offline.
When was updatable subscriptions removed from SQL Server?
Updatable Subscriptions – For Transactional Replication. This feature remains supported in versions of SQL Server from 2012 through 2016. This feature is in maintenance mode and may be removed in a future version of Microsoft SQL Server.
Can a subscription be updated at the subscriber or publisher?
Updates at the Subscriber Updates at the Subscriber are propagated to the Publisher even if a subscription is expired or is inactive. If TIMESTAMP or IDENTITY columns are used, and they are replicated as their base data types, values in these columns should not be updated at the Subscriber.
How to enable updatable subscriptions for transactional publications?
Enable updating subscriptions for transactional publications on the Publication Type page of the New Publication Wizard. To use updating subscriptions, you must also configure options in the New Subscription Wizard. On the Publication Type page of the New Publication Wizard, select Transactional publication with updatable subscriptions.
How does queued updating the publisher and subscriber work?
Queued updating The Publisher and Subscriber do not have to be connected to update data at the Subscriber. Updates can be made while the Subscriber or Publisher is offline. When data is updated at a Subscriber, it is first propagated to the Publisher and then propagated to other Subscribers.
How does transactional replication support updates at subscribers?
Transactional replication supports updates at Subscribers through updatable subscriptions and peer-to-peer replication. The following are the two types of updatable subscriptions: Immediate updating.