views:

555

answers:

7

I use SQL Server 2005, MySql, and Posgresql regularly. I'm tired of using Microsoft's SQL tool for SQL Server, phpMyAdmin for MySql, and pgAdmin for Postgres.

Is there a decent cross-platform GUI that I can use for all of these database servers? I don't care about the actual database administration part, I realize that each vendor's tool has specific functionality for administrative purposes. I just care about running queries on data. I prefer free, but if a good tool is going to cost me a little bit of money, that's fine.

Thanks!

+1  A: 

Navicat works for Oracle, Postrgres and MySQL

SQuirreL works for all the mentioned databases but I haven't tried it for a couple of years.

Brian Fisher
Go check out the last version of Squirrel, now!
alex
+1  A: 

You could take a look at Aqua Data Studio.

cxfx
I haven't run across this one before, thanks for the link. Great ER tool.
Trey
A: 

You could try a company called Toad by Toad Soft, they don't handle PostgreSQL, but there are tools for MySQL and SQL Server. If you are using vendor specific features, I'd recommend the IDE they provide, you're safest that way.

Chris
+1  A: 

Oracle Sql Developer is free and supports all of these except PostgreSQL. It also supports Oracle of course.

http://www.oracle.com/technology/products/database/sql_developer/index.html

Mark Harrison
+2  A: 

I'm a fan of dbVisualizer. It does all the standard stuff and it's got lots of features and goodies scattered throughout the product, including a nice diagramming tool. It's a commercial product but a free eval version is available.

jdigital
I've used this too. I prefer PL/SQL Developer for Oracle but otherwise this isn't bad.
cletus
A: 

Check this : http://www.sqlmaestro.com/ or this http://www.sqlmanager.net/ (MySQL, PostgreSQL, SQL Server and more)

Hugues Van Landeghem
+1  A: 

Try RazorSQL. It supports something like 25 databases and is a bargain at its current price.

Ahmad