Subject Re: FB suitability for Consolidated Database of 15 GB.
Author Aage Johansen
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.