Hi,
I would like to know if we can check merge replication conflicts
programmatically.
which tables do we need to check for replication conflicts?
By default some conflict_* tables are created. will these contain the
info?
Rgds,
amitmitsql,
yes the conflict_ tables contain the necessary information. In detail
they contain the column values of the losing replication partner plus
the reason for the conflict and the guid. If you want to be notified
when a conflict occurs you can create an insert trigger on the conflict
tables which either sends a mail or runs some sript/store procedure.
Markus
Tuesday, March 27, 2012
check replication conflicts programmatically
Labels:
conflicts,
conflictsby,
conflictsprogrammatically,
database,
merge,
microsoft,
mysql,
oracle,
programmatically,
replication,
server,
sql,
tables
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment