Groups | Blog | Home
all groups > sql server replication > october 2003 >

sql server replication : How to use staging tables in replication?


andsm
10/30/2003 9:26:03 AM
I designing DB, MS SQL2k. Problem with replication:
Need two-way replication, but in case of conflict special
user, expert, must solve such conflicts manually - not with
Conflict Resolver interface, but with user friendly interface. I
thinking of: transactional replication, replicate data to
staging tables. This tables must be filled with data from
actual tables, to apply transaction changes. After each
replication, run script which would detect conflicts and move
non-conflicting records to actual tables. Conflicting records
will be resolved by user. Possibly better, and more easy
ways exists to achieve such goal? May be merge replication
can be used? What is usual approach to solve such
Ray D
10/30/2003 9:06:30 PM
You can develop user-friendly interface to resolve
conflicts with the use of SQL-DMO replication objects.

[quoted text, click to view]
AddThis Social Bookmark Button