Hi Man-wai,
FoxInCloud makes all this very simple: - all user state being stored on server side, in case of server of network outage, user just retries until it’s fixed and resumes everything at the same point without any loss of state or data; - FoxInCloud ships with a VFP database 2-way sync tool over LAN or Web; each party asks the other party for records modified since a given date-time (taking into account time zone and time drift on both sides); the matching set of records is sent through the Network (LAN or Web). If nothing comes back or received records are invalid, process just stops until we take another chance; if sync fails for any reason (such as unique key violation), process also stops. When process stops for any reason, all previous changes are rolled back to keep DB consistency.
All this comes out of the box: no extra programming, debugging and testing!
Thierry Nivelet FoxinCloud Give your VFP app a new life in the cloud http://foxincloud.com/
Le 25 mai 2018 à 17:46, Man-wai Chang changmw@gmail.com a écrit :
When you go Cloud, You have to handle the worst-case scenario when a network partition happens. And what should you do when the network resumes operation after a network partition? How do you sync data between local apps and the cloud apps? It's way too complicated, which translates into extra programming, debugging and testing!
A terminal server is always a better solution, in my limited opinion.
On Thu, May 24, 2018 at 7:30 AM, Paul H. Tarver paul@tpcqpc.com wrote:
There have been more than one of my clients who make the move to the cloud only to find that key functionality that is required for their business to function properly is lost. This might be due to loss of direct access to their data, or worse, the cloud version of the ERP isn't nearly as complete or mature as the self-hosted product. Either way, it costs way more than just time and money. Sanity and common sense are often victims as well.
-- .~. Might, Courage, Vision. SINCERITY! / v \ 64-bit Fedora 25 Server Spin /( _ )\ http://sites.google.com/site/changmw ^ ^ May the Force and farces be with you!
[excessive quoting removed by server]