General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
VFP DBC or SQL SERVER
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only