Freeware SQL Client

[MikeVic]

Anyone have a good freeware SQL Client they can recommend? Or do people use SQuirreL?

[Neon_Chaos]

MySQL

[MikeVic]

I need something for SQL Server, if that makes a difference.

[sterlingice]

I remember using PostgreSQL for a couple of projects in school and that worked pretty well.

SI

[Celeval]

I use sqldeveloper, but that's an Oracle thing and I haven't tried it much with SQL Server.

[Celeval]

Is there a Toad freeware version for SQL Server? That might be worthwhile.

[Drake]

Does Aqua Data Studio work with SQL Server? I've still got the 4.7 free version installer for that somewhere around here. I could upload it for you. It's gone commercial since then, but I like it.

I liked Toad back in the day, but preferred Aqua Data ultimately.

Answering my own question: It looks like it does work with SQL Server through 7.0...anything later than that may be a crapshoot.

[Airhog]

The MSSQL Server Management Studio is available for free with the express version on the DB

[Fidatelo]

Will the SMSS that comes with Express connect to non-Express instances? If so, that's for sure the best bet.

Otherwise I'll second Toad, I've used it in the past against SQLServer.

[MacroGuru]

Navicat is what I use for MySQL but I think they have a SQL Server client as well.

[Drake]

Navicat looks pretty cool. I'm installing it now.

[Radii]

The MSSQL Server Management Studio is available for free with the express version on the DB

http://www.microsoft.com/downloads/details.aspx?familyid=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en


Microsoft SQL Server Management Studio Express (SSMSE) is a free, easy-to-use graphical management tool for managing SQL Server 2005 Express Edition and SQL Server 2005 Express Edition with Advanced Services. SSMSE can also manage instances of the SQL Server Database Engine created by any edition of SQL Server 2005.

Note: SSMSE cannot manage SQL Server Analysis Services, Integration Services, Notification Services, Reporting Services, SQL Server Agent, or SQL Server 2005 Mobile Edition.

Depends on your need to access those additional services I suppose. I use this for all of my work and find it to be more than satisfactory. I have no need to touch reporting or notification services, etc, our DBA does all of that.

[MikeVic]

Thanks I'm trying Toad for now, will see how it goes.

[MikeVic]

Toad seems cool. Is there a way to only run the selected SQL in an editor window, instead of all the SQL?

[rjolley]

shift-F9, I believe

[DanGarion]

I usually just use WAMP. But I guess it depends on what you are using it for...