Re: Preparing VFP programs for SQL Server

Tech-Archive recommends: Fix windows errors by optimizing your registry



Zootal seemed to utter in news:O8JVwW5vIHA.420@xxxxxxxxxxxxxxxxxxxx:

The architecture of the VFP database is such that it's not a server
database, and very susceptible to corruption. I wouldn't even call it a
DBMS as it lacks security and fault tolerance, and does little to
enforce data integrity. All you have to do is fart on it and your data
becomes corrupted. This you are already painfully aware of :-).

Oh, come on. VFP databases certainly lack a lot of the benefits
of an Oracle or SQL Server DB, but they aren't *that* fragile.

I've been running VFP apps for the past 15+ years with
thousands of databases (yes, thousands) and I can count on
one hand the number of times I've had corruption problems.
And none of them resulted in lost data - only index rebuilds.

VFP isn't the right DB for every situation, but neither is
Oracle. And VFP can stand up to a fart as well as the
next RDBMS. :^)

-- TRW
_______________________________________
t i m . w i t o r t
_______________________________________
.



Relevant Pages

  • Re: Preparing VFP programs for SQL Server
    ... VFP databases certainly lack a lot of the benefits ... one hand the number of times I've had corruption problems. ... had some rather serious network problems that caused network disconnection ...
    (microsoft.public.fox.programmer.exchange)
  • Re: stack overflow locking sysprocplan
    ... I'm now leaning towards a corrupt sysmaster database because since ... I wasn't around when we got IDS and created our databases ... the corruption? ...
    (comp.databases.informix)
  • Re: Corrupted files fpd2.5; vfp9 sp1
    ... With VFP, you can buffer the data, which greatly reduces the probability of corruption. ... You need to make sure you've rearchitected your application to use buffering when moving to VFP. ... The fpd version always suffered from sporadic file corruption. ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Rebuild DBC
    ... Make sure you have the most recent SP for your version of VFP. ... Possible Causes of Data Corruption in Visual FoxPro ... rather then reindexing the tables all the time. ...
    (microsoft.public.fox.programmer.exchange)
  • Re: which programming language ?
    ... > a vfp table. ... > Or can I simply state it like this: If I can open the others fileformat ... other than VFP but I've seen various things that could manipulate older ... you've lost the "easily" bit then because different databases have different ...
    (microsoft.public.fox.programmer.exchange)