Suggested replication type?
I have 2 similar tables in different servers, data in certain columns can only be changed by server A while data in other columns can only be changed by server B.
However, I need these tables to always be consistent (1 minute schedule). Is this the kind of scenario that "Transactional replication with updatable sub开发者_开发技巧scriptions" solves?
You want merge replication.
YEs, updateable subscriptions allow for this, but that is a deprecated feature:
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
The way going forward is Peer-to-Peer Replication.
精彩评论