Freeware SQL Client

MikeVic · 02-24-2010, 10:02 AM

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

Neon_Chaos · 02-24-2010, 10:03 AM

MySQL

MikeVic · 02-24-2010, 10:18 AM

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

sterlingice · 02-24-2010, 10:31 AM

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

SI

Celeval · 02-24-2010, 10:36 AM

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

Celeval · 02-24-2010, 10:37 AM

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

Drake · 02-24-2010, 11:04 AM

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 · 02-24-2010, 11:14 AM

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

Fidatelo · 02-24-2010, 12:26 PM

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 · 02-24-2010, 12:28 PM

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

Drake · 02-24-2010, 12:46 PM

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

Radii · 02-24-2010, 01:19 PM

Quote:

Originally Posted by Airhog

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

http://www.microsoft.com/downloads/d...displaylang=en

Quote:

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 · 02-24-2010, 02:00 PM

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

MikeVic · 02-24-2010, 04:40 PM

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

rjolley · 02-24-2010, 05:22 PM

shift-F9, I believe

DanGarion · 02-25-2010, 12:56 AM

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

02-24-2010, 10:03 AM	#2
Neon_Chaos Pro Starter Join Date: Nov 2004 Location: Parañaque, Philippines	MySQL __________________ Come and see.

02-24-2010, 10:31 AM	#4
sterlingice Hall Of Famer Join Date: Apr 2002 Location: Back in Houston!	I remember using PostgreSQL for a couple of projects in school and that worked pretty well. SI __________________ Houston Hippopotami, III.3: 20th Anniversary Thread - All former HT players are encouraged to check it out! Janos: "Only America could produce an imbecile of your caliber!" Freakazoid: "That's because we make lots of things better than other people!" Last edited by sterlingice : 02-24-2010 at 10:32 AM.

02-24-2010, 11:14 AM	#8
Airhog Captain Obvious Join Date: Aug 2001 Location: Norman, Oklahoma	The MSSQL Server Management Studio is available for free with the express version on the DB __________________ Thread Killer extraordinaire Yay! its football season once again!

02-24-2010, 12:26 PM	#9
Fidatelo Pro Starter Join Date: Nov 2002 Location: Winnipeg, MB	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. __________________ "Breakfast? Breakfast schmekfast, look at the score for God's sake. It's only the second period and I'm winning 12-2. Breakfasts come and go, Rene, but Hartford, the Whale, they only beat Vancouver maybe once or twice in a lifetime."

02-24-2010, 12:28 PM	#10
MacroGuru Coordinator Join Date: May 2003 Location: Utah	Navicat is what I use for MySQL but I think they have a SQL Server client as well. __________________ "forgetting what is in the past, I strive for the future"

02-24-2010, 10:18 AM	#3
MikeVic Head Coach Join Date: Mar 2003 Location: Hometown of Canada	I need something for SQL Server, if that makes a difference.

02-24-2010, 10:36 AM	#5
Celeval Pro Starter Join Date: Nov 2000 Location: Cary, NC, USA	I use sqldeveloper, but that's an Oracle thing and I haven't tried it much with SQL Server.

02-24-2010, 10:37 AM	#6
Celeval Pro Starter Join Date: Nov 2000 Location: Cary, NC, USA	Is there a Toad freeware version for SQL Server? That might be worthwhile.

02-24-2010, 11:04 AM	#7
Drake assmaster Join Date: Feb 2001 Location: Bloomington, IN	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.

02-24-2010, 12:46 PM	#11
Drake assmaster Join Date: Feb 2001 Location: Bloomington, IN	Navicat looks pretty cool. I'm installing it now.

02-24-2010, 02:00 PM	#13
MikeVic Head Coach Join Date: Mar 2003 Location: Hometown of Canada	Thanks I'm trying Toad for now, will see how it goes.

02-24-2010, 04:40 PM	#14
MikeVic Head Coach Join Date: Mar 2003 Location: Hometown of Canada	Toad seems cool. Is there a way to only run the selected SQL in an editor window, instead of all the SQL?

02-24-2010, 05:22 PM	#15
rjolley College Starter Join Date: Dec 2000 Location: Roseville, CA	shift-F9, I believe

02-25-2010, 12:56 AM	#16
DanGarion Coordinator Join Date: Nov 2003 Location: The Great Northwest	I usually just use WAMP. But I guess it depends on what you are using it for... __________________ Los Angeles Dodgers Check out the FOFC Groups on Facebook! and Reddit! DON'T REPORT ME BRO!

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)