Merge Replication possible?

zagato

hello,

i'm not sure, if this is the right forum - maybe sql toolkit...?

i've read your homepage and i saw the table with possible replication with sql data compare. in that table there is an column "merge replication" (with toolkit)
now my question: is it possible to implement something like a "pull merge replication" with sql data compare or the sql-toolkit?

i want to replicate data between two databases in both directions. a timestamp and author-column is in every table. is this possible?

thanks in advance!

Roland

Brian Donahue

Hi Roland,

yes -- but it's extremely messy and you'd need Toolkit to do it. You have these tools at your disposal with SQL Data Compare's engine:

• WHERE clause to filter out the data that you don't want to synchronize
• SelectionDelegates to exclude records from synchronization based on a certain criteria (ie date in db1 is older than date in the same column in db2)
• IncludeRecordsIn1 and IncludeRecordsIn2 to prevent the synchronization from deleting any data in either direction so that only INSERTs and UPDATEs are scripted.

There should be examples of these in the Toolkit Sample Files.

zagato

sounds good, i'll give it a try!

thanks!