Sam wrote: << ... Take a look at the Synchronization Example at the bottom of this link: http://msdn.microsoft.com/en-us/sync/bb821992 It explains the basic concept of how Sync Framework syncs the data. The whole key to it is the "Update Tick Count" which is database wide. In the Microsoft world is the @@DBTS function. They refer to this function as either the timestamp or as the rowversion. ... >>
When I read about maintaining "tombstone information" (for deleted items) I thought that replication - while not a simple solution - might eventually be a better choice. YMMV. A point to note is that InterBase and Firebird may be talking a lot on the wire (at least they used to) meaning that they might not be the very quickest performers over the internet. Again, YMMV. -- Aage J.