Hi Dennis,
FoxInCloud includes a synchronization class that does all your requirements, including support of
- deleted records
- sync set of tables or full database (top-down using relations)
- 2-ways or either way
- rollback in case of an error
- comprehensive log including records where sync failed
- various other settings
- you can sub-class for whatever extension you see fit
Conditions:
- 'central' database is behind a Web Application
- each table has a primary or candidate key and 2 normalized fields: 'last update' and 'updated by sync'
- batch execution, not real time: each 'client' runs a program periodically (can be every minute)
In production since 2009.
>Hi Guys,
>
>Basically, I am doing a POS app which will be used by a handful of branches and one head office. All will be connected via internet.
>
>We would like for the following to be implemented:
>
>1. Whenever head office say creates, deletes or modifies a new product, it will be propagated to the Products table of each branch.
>
>2. Conversely, branch sales data feeds are pushed to the head office.
>
>3. In the event that internet connection fails during this "synching", how does one know where "we left off" to continue?
>
>Thank you very much in advance for all your efforts!
>
>Long live the Fox!
Thierry Nivelet
FoxinCloud
Give your VFP application a second life, web-based, in YOUR cloud
http://foxincloud.com/Never explain, never complain (Queen Elizabeth II)