Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

vfp or sql server

vfp or sql server

vfp or sql server

Our company is currently using vfp 5.0. We are looking to grow.  We were wondering if vfp would be able to keep up speed and dependability as we grow, or should we go to sql server?  Any tips would be appreciated.

RE: vfp or sql server

I've been using Fox since '87, and use it exclusively for client-side development.  I've been using SQL Server for a couple of years.

If I was tasked with developing a reliable, scalable, and flexible system, I believe this is the best combo:

    VFP client
    SQL Server database

Reliability: the DBF format is famous for data corruption.  Its gotten better, but remains a problem.

Scalability: I've used SQLS7 on a 100Gb database, with the largest table holding 270 million records.  All this on a $75K machine.

Flexibility: Somewhat of a toss-up; both can be tied to Web pages fairly easily, but SQLS can be accessed directly via TCP/IP from anywhere.

I think the combination of VFP/SQLS plays well to the strengths of both products.

I would still use the native DBF though for "shrink wrapped" mail-away type applications.

Robert Bradley

FoxDev - Visual FoxPro Development

RE: vfp or sql server

Besides what Robert said if security is an issue you really have no choice but go with a data server like SQL Server.  There is a 'desktop' version of it which I know nothing about and runs on Win98 I think but generally going with SQL Server means you will need to go with NT Server or Win 2K.  If you post more specifics like securtiy, budget, scalability needs, etc you may find out more helpful info to help you decide.  HTH

John Durbin

ICQ #9466492
ICQ VFP ActiveList #73897253

RE: vfp or sql server

Excellent point, Jon; I made a grave mistake not mentioning security, and security is not to be taken lightly, even in a closed environment.

As we all know, VFP and the DBF format provide absolutely no built-in security mechanisms on any level.  No matter how bullet-proof we make our VFP app's security, anyone with access to the raw DBFs can read them.  We can introduce encryption, but that greatly increases the complexity and negatively affects the performance of the application.

Database servers have excellent security built-in.

Robert Bradley

FoxDev - Visual FoxPro Development

RE: vfp or sql server

I think, thank because VFP5 and VFP6 work with SQL-Server
With SQL-Sever you have all the protection and securities that you had with
The main frame for example  all the write procedures  is running in the server if something happened in the work station  the data will be OK  but if we work just with a LAN, if something  happened with the workstation that could corrupt the *.dbf in the LAN-server.

The only two inconvenient  I found working with SQL-Server :

1o. You have to make the whole and detail design before you start, because change something in the middle of the road is a pain in the neck  or when the program is running and you boss want some modification, even now with SQL-server 7 a lot of things become easier.

2o. Because SQL-server is other Sever running inside  of one  computer in your LAN usually the same NT-server, you have to hire or give training to someone to be the SA (system Administrator) for you SQL-server, so now you have two Administrator one for the NT and other for SQL.

Therefore I believe SQL-server is not for small business.

RE: vfp or sql server

Microsoft did a great job making SQLS7 self-tuning.  That, plus the decent tools that come in the box, gives your average VFP'er at least a decent shot at being to set up and run a smallish-sized SQLS/VFP combo.

Robert Bradley

FoxDev - Visual FoxPro Development

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close