Merge Replication possible?

zagatozagato Posts: 5

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!



  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    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.
  • Options
    sounds good, i'll give it a try!

    thanks! :)
This discussion has been closed.