Cross platform Database IDE
Ever since I've moved to using Linux full time I've been looking for a solid Database IDE. I've tried and tested quite a few.
- Aqua Data Studio
- This is my current DB IDE of choice and has some significant features in the new version 6.5 that means I'll be staying with it for a while, particularly as it runs on Linux, Macs and Windows identically.
-
- Schema Comparison - very handy for keeping development and production db's schemas in sync.
- Charts & Pivot Tables - makes it easy to create adhoc graphs withouth having to resort to Excel/OpenOffice Calc
- Morph to Delimited List - A simple but powerful function that saves a lot of time. Allows you to take the results of a sql query and convert to comma seperated list. I've done dozens of adhoc CF scripts to handle this before :-)
- Subversion Support - As we use subversion for our code it's handy to have it built in.
- MySQL GUI tools (Query Browser & Admin)
- These have some very nice functionality but have always found them to be pretty unstable - they just crash a lot with no explanation.
- Navicat
- This is pretty good option, but the Linux version is the poor cousin to the Windows & Mac versions.
Love to hear any comments feedback or suggestions.
There are also a few db related plugins for Eclipse.
I presume Oracle SQL developer is specifically for Oracle DB's? Or can it handle other db's also. The one thing I miss from the MS SQL Enterprise manager is the Diagram's which was the way I used to do all of my table editing.
I have tried some of the eclipse plugins but never got far with them. I may revisit them again given my understanding of jdbc connections strings is much improved now, but at the moment I think I'll keep exploring the Aqua Data Studio - I've been using it for almost 12 months and am still learning new things about it.
Yes - setting up the Eclipse tools can be a bit tedious but I use CFEclipse daily so it's convenient to have that view handy.
I just downloaded the Oracle SQL Developer
http://www.oracle.com/technology/products/database...
Definitely an option that I'll need to explore further, it's very easy to add the MySQL driver to it. Thanks for the feedback.
Cheers,
Mark