CODEWITHSUNDEEP
sql-serversql-server-2005transactionsreplication
Eton B.
Eton B.

Reputation: 6281

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 subscriptions" solves?

Upvotes: 4

Views: 199

Answers (2)

Joe Stefanelli
Joe Stefanelli

Reputation: 135729

You want merge replication.

Upvotes: 2

Remus Rusanu
Remus Rusanu

Reputation: 294197

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.

Upvotes: 2

Related Questions