>>We do it ourselves yet (don't know if a 3rd party exists). But I wonder, does this "Manager" do it without any user intervention (except dialing etc) ?
>
>How do you do this? Do you create a transaction log? Are you willing to share your knowledge and code?
>TIA.
Of course I would share. Just give me some time to make some generalization on code (if kid lets me I'll do it tonight). I use different strategies based on clients. For a startup here is what I do (it seems kid will only let to write a few more lines for tonight) :
- Some of clients want to check modified records. For those I do a union first, than present them the duplicates (any change in any field would produce a duplicate) and let them to select the correct one.
- For others one of the sites (there are two sites working async in this type) is the master and the other is slave
Before data transfer a routine classifies the data as appended, changed and deleted on both sites.