views:

198

answers:

5

Is there any good tool for working on Dabtabase apart from Toad which requires license and DBVisualiser not supportive

A: 

Try fabForce Database Designer; it is GPL too. http://fabforce.net/dbdesigner4/

A: 

I am using the free version of WinSQL.
I am also looking at SQLDeveloper from Oracle. I have heard it mentionned in the same breath as Toad.
In a pinch, I find that Microsoft Query, which comes with Excel, is more than adequate.

AJ
+1  A: 

i'd recommend oracle SQLdeveloper. it has all the functionality you need for developing and maintanice

janbom
A: 

I've always used Golden 32 from Benthic - it's simple, cheap, and has the most common features I need (queries, viewing relationships, editing data). It's Oracle only. Aqua Data Studio from AquaFold is another option that supports multiple databases and has a ton of features, but it much more expensive. I used it for a while but kept going back to Golden because of how fast and easy to use it was.

Brian Deterling
A: 

I find SQuirrel SQL Client is an excellent tool. It requires Java so depending on how you feel about that it may be a good thing or a bad thing. I find it's nice because I work on Windows, Linux and OS X and it works great on all platforms. If you work only on one platform you might be able to find better clients for that particular platform.

It has plug-ins for a lot of different databases, allows in table editing, has a data modelling module, auto-completion in the SQL editor and lots of other nifty features.

http://www.squirrelsql.org/

SQuirrel is currently released under GNU Lesser General Public License.

mithu