Subject | How to maintain coherence between 2 databases |
---|---|
Author | henry FRANQUET |
Post date | 2004-07-27T14:28:15Z |
Hi,
I have a Firebird 1.5 database on laptop which is a subset of a
large database on a server (some tables, some fields and some
records).
On the laptop, a monouser application in Delphi 5 and IBObject
TIBOTable and TIBOQuery update the local database. From time to
time, say every week or every two weeks, I have to update, via a
modem (at least 33Kbs), the server database with all the
modifications made to the local one
What is the best strategy with IBObject?
1) having 2 local databases (one before modification and one after,
compare the 2 and create queries to update
2) use of a table of modification witch key is tableName, keyName,
keyValue
3) another solution
a) update via SSL and TCP-IP links
b) transfert a file for updating (not as easy to solve dual
updating on local and server database of the same data)
Is there some tricks in ibobject to identify if a field has changed
Thanks
I have a Firebird 1.5 database on laptop which is a subset of a
large database on a server (some tables, some fields and some
records).
On the laptop, a monouser application in Delphi 5 and IBObject
TIBOTable and TIBOQuery update the local database. From time to
time, say every week or every two weeks, I have to update, via a
modem (at least 33Kbs), the server database with all the
modifications made to the local one
What is the best strategy with IBObject?
1) having 2 local databases (one before modification and one after,
compare the 2 and create queries to update
2) use of a table of modification witch key is tableName, keyName,
keyValue
3) another solution
a) update via SSL and TCP-IP links
b) transfert a file for updating (not as easy to solve dual
updating on local and server database of the same data)
Is there some tricks in ibobject to identify if a field has changed
Thanks