>Hi Everyone,
>
>I've installed same application on two sites. One is in Singapore and other in Indonesia.
>
>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.
>
>Can anyone guide me what are the best practices for this.
>
>Please note data can be modified/ammended at either site, however creation is always from Indonesia.
>
>How do I synchronize both databases so as, Indonesia can send records created/modified by them as well as can receive modifications done by Singapore to their data.
>
>And how does singapore can receive data, sychronize with Indonesia, modify and send back changes.
>
>A little confuse here, will appreciate help from you geniouses.
>
>TIA
Shaishav,
I sent an article years ago that targeted fox2x too, unfortuantely I don't even remember the name of it, you might find it searching.
However with VFP check offline views (createoffline(), dropoffline(), use online..admin). You can't insert, pack,zap them but not a problem since owner side should do insert and both sides could do modification.
Also you could use VFP7's XMLupdategram() to log and send only insert,delete,update xmls.
You could also use VFP ActiveDoc and web but that should be slow.
Cetin