Hi!
>>
Singapore and Indonesia maintains their own databases. Now we want to merge the information. In such a way that Indonesia can update their information locally and later upload to Singapore server, where the data will be merged to Singapore database.
<<
There is no native way in VFP to handle this case!
Some ideas:
- write logfiles to collect the informations about changed/created/deleted records
- based on this log files create a related subset of all changed data and send it to the other site
- process the logfile and the releated data
Be aware of some important things:
- If both sides changed a record, you need some rules to handle this ("the last wins" or other rules)!
- What about dealing with more than one change of one record between two merges (modify a record, modify it again, then deleting...)?
- What about dealing with primary keys?
- What about dealing with changes in different child records of a parent record to ensure the business integrity of your data?
Concluiso: Be sure you will have a
hard, hard job (I did such a job some month ago for a data model with about 100 tables - and it tooks me more than half a year of work to handle all the needed stuff!).
SeBaFlu