Hi everyone,

I've got a project in front of me that can be described like this:

1) Remote database containing a few gazillion records in thousands of
tables

2) Windows "fat client" application that needs to locally store a
subset (the end-user's portion) of the table data from the remote server

3) End-user can add, delete, or modify local copy of data at will
without a connection to the internet

4) End-user synchronizes their local copy of the data back to the
remote database at irregular intervals

My mental picture of the project is much like a Palm/PDA
synchronization of the records owned by the end-user.

I'm contemplating using embedded FB to store the local-side data. Is
the IB 6 documentation still the best source of information for using
embedded FB?

I could build this type of synchronization method from scratch, but
since I'm in a time crunch I would much prefer to purchase an
off-the-shelf mechanism. Can anyone suggest possible toolsets to
accomplish this task?

I've started with a cursory review of a few "middleware" toolsets
(Asta, Midware, kbmMW) but these tools don't seem to meet my
requirements without tons of tweaking, unless I am mistaken.

Best Regards,

David Montgomery