Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP reliability (Big database)
Message
 
To
24/01/2007 14:32:39
John Ryan
Captain-Cooker Appreciation Society
Taumata Whakatangi ..., New Zealand
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01187486
Message ID:
01188889
Views:
21
>Moving to C/S does not prevent corruption and if a SQL Server record is physically corrupt you may see lockups merely trying to access it. But they are much less common. A properly maintained C/S database can deliver effectively permanent reliability/availability for years.

Amen. All of the data I store in any of the systems I design or work with now is in SQL Server because of the rock solid reliability of the data store. Make sure the server itself is solid and up-to-date and you will rerely if ever have data corruption (at least not at the server or database level - a user can still store garbage if their program and the database allows).

It took several months to really get into using SQL Server data instead of VFP tables, but once I got the hang of it I never look back!

BTW my primary client stores medical data for millions of people gathered over the last 20 years from multiple earlier companies. Primary database size is approx 100GIG. We have had no corruption in the almost 2 years we have been using SQL server as the data store (previously stored on a mainframe and various other database systems).
____________________________________

Don't Tread on Me

Overthrow the federal government NOW!
____________________________________
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform