Hi Simon, >Method 2 >-------- > >Ignore Method 1. In each copy of your database keep a log of all >INSERT and UPDATE commands executed since the last 'synchronize': > >CREATE TABLE commandsSinceLastSynch (theCommand TEXT) > >To synchronise the two copies, play back the log for copy A to copy B >and the log for copy B to copy A.
Things are not that simple: you need to handle the case where a row has been updated in both DBs. Comparing update commit (important!) timestamps in both logs helps determine which one got first/last. Of course if triggers changed more and timestamps are close enough then FUD enters the room.