David -



The TClientDataSet in Delphi is made to do what you are asking. It allows
you to run queries to collect data locally (in memory); then it allows you
to persist that data to disk (XML or proprietary binary format). It will
also build a change log that holds all inserts, updates, and deletes, and
finally, it will let you update the source database with any changes stored
with a complete conflict resolution mechanism.



The only fear that I have about using the TClientDataSet in your environment
is the quantity of data you intend to store locally. Do you have
anticipated volumes of data per end-user?



Louis Kleiman

SSTMS, Inc.



-----Original Message-----
From: David Montgomery [mailto:montgomery_list@...]
Sent: Tuesday, May 20, 2003 6:36 PM
To: ib-support@yahoogroups.com
Subject: [ib-support] Record-level synchronization



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






Yahoo! Groups Sponsor



ADVERTISEMENT

<http://rd.yahoo.com/M=244522.3313099.4604523.1261774/D=egroupweb/S=17051153
86:HM/A=1588191/R=0/*http:/ashnin.com/clk/muryutaitakenattogyo?YH=%25LINEID%
25&yhad=1588191> Click Here!



<http://us.adserver.yahoo.com/l?M=244522.3313099.4604523.1261774/D=egroupmai
l/S=:HM/A=1588191/rand=710015297>


To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo!
<http://docs.yahoo.com/info/terms/> Terms of Service.



[Non-text portions of this message have been removed]