Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Moving from FoxPro's DBC to MSSQL Server
Message
From
09/11/2005 05:38:53
 
 
To
09/11/2005 00:24:44
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01066358
Message ID:
01066712
Views:
20
Hi Bernard,

>Once you go past MSDE to a full blown SQL system you will find that there are no longer speed restrictions but restrictions on your pocket with the extra grunt of a new server cost, User License fees per user/processor etc. Hope your wallet is bottomless or at least huge and stuffed with cash.

With CA C/S is no more an issue on VFP. VFP8 and 9 "Cursor adapters" thru ODBC + DB engine, you have really an flexible and effective data-crunching combo.

Once MSDE has reached its limits, no absolute need to use the big league except if you run Terabytes warehouses. You can consider alternatives such as firebird (free - good for MB) or Sybase ASA 9 (unexpensive and flexible up to a couple of GB).

These tools run on linux as well. Potentially another way to save a couple of extra bucks.

My 0.2 cents

Franck
Previous
Reply
Map
View

Click here to load this message in the networking platform