VFP9 options in the cloud (and elsewhere)
Posted on 2016-07-29
I am looking at options for keeping a 20 user VFP9 application on a LAN happy for the future.
Data volumes are not high, but it does handle accounting, inventory, scheduling, orders, EDI etc. for a manufacturing company.
About 150 tables in 6 dbc's, total size about 360 meg.
After a server crash that took a day to recover from we are looking at options for faster recovery.
We do not use client/server, so from what I read a cloud base for dbf's (as oposed to SQL Server) is an invitation to data corruption, unless a very fast connection is available? Our current connection is 55 down and 11 up and I suspect we can pay for faster. But I still just don't trust the internet. Could be wrong?
We have had no corruption issues since day one, and I would like to keep it that way.
Not sure I have the energy, knowledge or time (66 years old) to rewrite (and test) everything to make it client/server.
Our current network supplier, who is also offering the cloud, will do a 'resilient cluster' for a local hardware solution.
1. Resilient cluster
2. DBFs on cloud (exes on local staions)
3. Rewrite for remote access on cloud
4. New software entirely.
This company has done well for me for 40 years and vice versa, so I want to be sure they are in good shape. If that means stepping aside for entirely new software, or bringing someone on for a rewrite--fine by me!
I've taken a quick look at ActiveVFP and FoxInCloud and not sure they fit this situation.
All thoughts welcome.