02-24-2010, 10:02 AM | #1 | ||
Head Coach
Join Date: Mar 2003
Location: Hometown of Canada
|
Freeware SQL Client
Anyone have a good freeware SQL Client they can recommend? Or do people use SQuirreL?
|
||
02-24-2010, 10:03 AM | #2 |
Pro Starter
Join Date: Nov 2004
Location: Parañaque, Philippines
|
MySQL
__________________
Come and see. |
02-24-2010, 10:18 AM | #3 |
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:31 AM | #4 |
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, 10:36 AM | #5 |
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 |
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 |
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, 11:14 AM | #8 |
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 |
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 |
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, 12:46 PM | #11 |
assmaster
Join Date: Feb 2001
Location: Bloomington, IN
|
Navicat looks pretty cool. I'm installing it now.
|
02-24-2010, 01:19 PM | #12 | ||
Head Coach
Join Date: Jul 2001
|
Quote:
http://www.microsoft.com/downloads/d...displaylang=en Quote:
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. |
||
02-24-2010, 02:00 PM | #13 |
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 |
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 |
College Starter
Join Date: Dec 2000
Location: Roseville, CA
|
shift-F9, I believe
|
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
Thread Tools | |
|
|