tags:

views:

530

answers:

8

I'm looking for a free and lightweight SQL IDE that can support MS SQL and Oracle. I have tried Aqua Studio and Rapid SQl, and they both are not free, and a bit bloated.

Any recommendations?

+1  A: 

try toad

Ahmed Said
he said a *good* IDE :)
skaffman
A: 

Foxy SQL Free 1.0

DreamCoder for Oracle Freeware 4.1

Toad

joe
A: 

EditPlus 3 is a great IDE. And it supports making language packs so there is a whole community behind it to support any new features.

Also, for SQL Server I always suggest to people to try the LINQ Pad. It is a lot of fun and gets you away from mundane SQL when you don't want to write it.

Andrew Siemer
+1  A: 

I'm not sure what you are looking for when you say SQL IDE, but a very good frontend for various DBMSs is DBVisualizer. Unfortunately, the free version lacks important features so I would recommend to buy it. It costs 149 $ and is totally worth it!

Tim Büthe
They may well be, but the question is for a free tool.
skaffman
As I said, there is a _free_ and a so called personal version of DBVisualizer.
Tim Büthe
+3  A: 

For Oracle, the Oracle SQL Developer is the best free tool I could find.

Karl Bartel
Sadly, this seems to be true. It's just not very good.
skaffman
+1, it works and supports both MSSQL and Oracle. It's okay.
sheepsimulator
A: 

Netbeans has a pretty decent data base tool inside...

daniel
+2  A: 

For MSSQL:

SQL Server Management Studio Express

Very easy to use

Egg