Re: FoxPro vs. SQL

"Alex S" <asluiter_at_gmail.com> wrote:

> My company uses a FoxPro database right now as an interface
> and a database. For our situation, I have come to the conclusion that
> it would be a better choice for us to move to an SQL server of some
> sort.

There are several things that would help us provide an answer.

Volumes of data. Number of transactions per second/hour/day. Preferred operating system. Deficiencies of your present system - what are they? How do they impact on your business? How much RAM does your server have? Current server configuration. Do you have hardware plans also?

My own personal choice would be to invest in Dephi as the front end and then use Firebird and/or PostgreSQL as the backend. Both of these open source dbs will run on minimal hardware and a variety of operating systems and are very powerful and have paid support available if required, often by the very people who write the dbs in the first place.

There are any number of free development environments out there also.

Paul...

> Alex

-- 

plinehan __at__ yahoo __dot__ __com__

XP Pro, SP 2, 

Oracle, 9.2.0.1.0 (Enterprise Ed.)
Interbase 6.0.1.0;

When asking database related questions, please give other posters 
some clues, like operating system, version of db being used and DDL.
The exact text and/or number of error messages is useful (!= "it didn't work!").
Thanks.
 
Furthermore, as a courtesy to those who spend 
time analysing and attempting to help, please 
do not top post.