Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP DBC or SQL SERVER
Message
From
20/09/2005 01:10:41
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
VFP DBC or SQL SERVER
Miscellaneous
Thread ID:
01051136
Message ID:
01051136
Views:
59
Hi:

Presently, I am using SQL Server as the back end for a VFP application.
I'm getting ready to setup a duplicate system in another location ... and a few more location in the near future.
It's been bothering me for years that perhaps SQL Server is not needed - over kill for this application.
Why did I decided on SQL Server in the first place?
Less data corruption problems ... and to-date, not a single database problem.

There are 15 work stations on this netowrk, and the application is installed on all 15 workstations.
Each workstation queries and/or writes to SQL Server every 0.25 second - via a VFP timer in the application.
The largest table has only about 20,000 records.

My question is:
How can I make a VFP Database as reliable as SQL Server?
Will 3rd party application make it more reliable?
Is VFP Database 9.0 different from the past and more reliable?

TIA

Mal
Next
Reply
Map
View

Click here to load this message in the networking platform