Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Oracle or VFP Database
Message
From
21/11/2000 01:41:56
 
 
To
20/11/2000 20:01:19
Cindy Winegarden
Duke University Medical Center
Durham, North Carolina, United States
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00443636
Message ID:
00443970
Views:
8
It might be close, but no cigar. We are talking about comparing an Enterprise Client Server database system to a fileserver based database system.

With VFP, you are almost guaranteed fo getting a corrupt DBF during a power loss. Not to mention the possibilities of DBF/CDX corruption if a user powers down while a VFP app is open.

VFP with DBFs doesn't even compare to the robustness of client server system. One of the big reasons for using SQL Server/Oracle vs. something like VFP.

PF

>Perry,
>
>FoxAudit sure comes close!
>
>
>>I would assume that what the analyst was refering to was an enterprise database system such as Oracle's abiliity to write out transactions to a log file. This is an automatic process that will help the database recover from a system crash. A fileserver database system, such as VFP is not going to be able to offer protection to that level.
>>
>>
>>>I had a question from one of our analysts asking how good VFP's restoration after a corrupt table was.
>>>
>>>This was a comparison to Oracle, in which I responded that VFP's tables would have to be restored via NT's tape drive and didn't have any means of restoring corrupt/damaged files itself, although there are products out there can restore corrupt tables - but I'm not sure how good these are as opposed to Oracles own recovery devices.
>>>
>>>Is that incorrect, or is that the bottom line to such a question?
>>>
>>>Thanks
>>>Kev

(On an infant's shirt): Already smarter than Bush
Previous
Reply
Map
View

Click here to load this message in the networking platform