Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
.Net the only alternative to VFP?
Message
From
31/03/2007 13:10:23
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
01208148
Message ID:
01210792
Views:
26
>Would you care to enaumerate the areas that SQL is superior ?

>Security ?
Inexistant in VFP, very ok in SQL server

>Speed ?
In a standalone application i guess VFP leaves SQL server behind, but not with such big distance. In a multiuser environment with little users, they may compare, in bigger environments I think SQL server will win. Very difficult to compare ... The legendarious speed-difference it had when VFP came out has mostly been eliminated, the gap is closed ...

A big diff in performance which I find VERY important : access to vfp data on a slow network like the internet is horrible (not to say impossible), on sql server it works like a breeze ...

>Ease of Use ?
SQL server is client server, browse a whole table, changing order on the fly like we do in VFP isn't possible or not that easy. You need to change habbits. I wouldn't discuss on this issue ...
On the other hand, transactions/tablebuffering in VFP : I don't like them. I think their not worked out good in VFP (they tried to mimic (with tablebuffering) the disconnected data model but due to compatibility reasons implementation is poor). In SQL server transactions are easy.

>Robustness ?
This is a major issue : sqlserver leaves VFP far behind (lightyears if you ask me). VFP is not able to enforce integrity (eg ref. integraty, you can store values in fields that should not go into it (a num field returning ***))
For me this is the main reason to choose for sql server.

>Scalability ?
VFP is little scalable, SQL server can go full range (depends on the server)

>Ease of getting data in and Out ?
SQL server uses standard sql for everything. So both can do all what you would need. Sql servers Sql-implementation is more complete (you can do more complex select's with all sorts of subqueriers etc...)

>Other ?
Maintainablity :
- backup while tables open
- other maintanance (handling indexes etc ...) while tables are open
For all this in VFP you need exclusive access, not in SQL server
- enterprise manager (don't remember the new name) : great tool for maintanance
- sql server agent : schedule all kind of tasks
- lot's of more

Small remark : this is just a personal opinion, and is not meant to be complete.
Previous
Reply
Map
View

Click here to load this message in the networking platform