Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Backup system for VFP database?
Message
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01200105
Message ID:
01200316
Views:
26
Hi Mike,

> is it really the best, simplest tool for the job?

"best" as in "my first choice" if I had multiple choices? Certainly not.

If you have a time where no-one is working in the application (in fact, not changing data is sufficient), any commercial backup utility is a better choice than VFP.

However, if you don't have any or sufficient down time, I haven't yet found an alternative. All serious backup tools that I'm aware of handle a single open file just fine. But for application level integrity they need application specific modules. There are tools for backing up SQL Server, Exchange Server, Oracle, mySQL, and so on. But I'm not aware of any backup program that works with VFP files and handles even the problem of backing up only consistent sets of DBF/CDX/FPT, even less tools that handle VFP's transactions properly.

99.99% of the time a backup program that can save open files will work just fine. But the remaining 0.01% you end up with a corrupt database when you restore a backup.
--
Christof
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform