Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP vs. SQL Server
Message
From
28/06/2001 03:32:46
Rene Van Den Berg
Infertility Database Systems Ltd
Islington, United Kingdom
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00523306
Message ID:
00524528
Views:
13
>Rene:
>
>I've done a lot of work with SQL Server over the last few years, and while it has a lot of nice features, I still think VFP has a lot to offer. Here are a few areas where VFP may have an advantage over SQL Server.
>
>(1) No licencing issues with VFP.
>
>(2) VFP can be setup thin client. A VFP application running on the server (COM object or Web Service) executes your queries in their own memory space just like a SQL database. Use XML to communicate with server side components.
>
>(3) The VFP cursor engine is FAR superior to SQL Server. Trying working iteratively with a SQL Cursor. Its a joke!
>
>(4) The VFP language is way more flexible than T-SQL.
>
>(5) SQL Server can not act as a file server database.
>
>(6) No DBA needed with VFP.
>
>The main advantage of using SQL Server over VFP is security and data integrity. However, there are ways to get around it.
>
>Hope this helps,
>Charlie

Thanks Charlie, this is the kind of list I was looking for.

Rene.
Previous
Reply
Map
View

Click here to load this message in the networking platform