Registered: Jan 2001
Location: Seattle, WA USA
Posts: 413

Looking for a WINDOWS SQL Compiler other then MS-SQL

Hi All,

I'm looking for a Windows SQL Compiler that will compile the query language. I know that everyone will most likely refer me to SQL Server, however, that costs money.

I'd just like to use it to analyze some SQL scripts. The program must be able to work in a windows environment.

Can anyone recommend anything to me? Freeware or shareware?

Thanks!

__________________
My References | My Gadgets | My Auctions

Registered: Jul 2000
Location:
Posts: 3034

http://www.mysql.com?

Registered: Jan 2001
Location: Misplaced Canuck in Charleston SC
Posts: 257

I second the MySQL recommendation. You can download a Windows installer version that will give you pretty much a fully functional RDBMS. there are a few things that MySQL doesn't do, like subselects but you probably won't miss them.

while you're at it, download and install Apache, PHP and phpMyAdmin, and you'll be able to admin your MySQL databases with a webserver.

__________________
-----BEGIN GEEK CODE BLOCK-----
Version: 3.12
GS d-(+) s: a C++ UX++++V++S++ P+>+++ L>+++ E+>++ W++ N++(+++) o? K? w !O !M V-- PS PE Y+ PGP++ t++ 5++ X++ R+ tv++ b++(+++) DI++++ D+ G++ e+++>++++ h--- r+++ y?
-----END GEEK CODE BLOCK-----

Registered: Aug 2000
Location: Alive and well on VisorCentral.com
Posts: 861

You can download the DB2 Personal Developer's Edition for free.. and that's a full blown RDBMS...

http://www-3.ibm.com/software/data/...dition-pde.html

I think this is the direct link:
http://www14.software.ibm.com/webap...ACT=&S_CMP=

(I have nothing against MySQL, I love it and use it myself (as well as using Sybase and Db2), just trying to offer alternatives)

__________________
"One of the most important things you learn from the internet is that there is no �them� out there. It�s just an awful lot of �us�." -- Douglas Adams

Registered: Jan 2001
Location: Seattle, WA USA
Posts: 413

Thanks for the suggestions!

__________________
My References | My Gadgets | My Auctions

Registered: Sep 1999
Location: Sydney Australia
Posts: 1883

Re: Looking for a WINDOWS SQL Compiler other then MS-SQL

quote:

---

Originally posted by MitzEclipse
I'm looking for a Windows SQL Compiler that will compile the query language.

---

Mmmm interesting choice of wording.. personally I never see SQL are a programming language which gets compiled.. it's a Query Language which gets executed..
But I guess I'm nitpicking

mySql is probably your best free option indeed...

__________________
<IMG WIDTH="200" HEIGHT="50" SRC=http://www.visorcentral.com/images/visorcentral.gif> VisorCentral Discussion Moderator
Do files get embarrassed when they get unzipped?

Registered: Nov 2002
Location: Los Angeles, CA
Posts: 3

SQL Server

You can also download a 120 day evaluation version of Microsoft SQL Server if you only need to do analysis.
Look for it at http://www.microsoft.com/sql

Registered: Jan 2001
Location: Seattle, WA USA
Posts: 413

Thank you much!

__________________
My References | My Gadgets | My Auctions