Is there a free SQL engine out there

[lashwarj]

Is there a free sql engine out there?

 

[ramani]

Hi

If you insert your VFP install disk, you will get an option to install..
Install Microsoft SQL Server 2000 Desktop Engine (MSDE)

Select this link to install MSDE, the desktop version of SQL Server 2000.

This you can say as a limited SQL server.




ramani
(Subramanian.G),FoxAcc, ramani_g@yahoo.com

 

[xBaseDude]

I know MySQL is open source, might be free...

http://www.mysql.com/

Haven't used it myself.

HTH - Wayne

...all this and tap dancing too!

 

[lashwarj]

how do you add a databse to the MSDE, is there a consol like the sqlserver cousol

 

[dchristensen]

There are several good SQL database engines available depending on the platform that you're going to run them on. For either Windows or LINUX, you can use MySQL, PostgreSQL or even Firebird.

Using MySQL for several systems and it's working VERY well.

My two cents...

 

[Mike Lewis]

Lashwarj,

As Ramani rightly points out, MSDE is free, and you already have it. It also has the benefit of being the same engine as SQL Server (with some limitations).

It's true that MSDE doesn't come with any desktop tools. It is intended for run time use only. However, if you can get hold of a demonstration version of SQL Server 2000 (I know they exist, but am not sure how to find them), you can install the enterprise manager and query analyser, both of which work with MSDE, and will give you pretty well all the desktop control you want.

Mike


Mike Lewis
Edinburgh, Scotland

http://www.ml-consult.demon.co.uk