Aqua Data Studio is a SQL editor and developer tool that allows developers to easily create, edit, and execute SQL scripts, as well as browse database structures. Aqua Data Studio provides an integrated database environment with a single consistent inferface to all major relational databases. This allows the DBA or developer to tackle multiple tasks simultaneously from one application. The application is multi-platform as it is written in Java. Screenshots here.
Aqua Data Studio 1.0 Released
About The Author
Eugenia Loli
Ex-programmer, ex-editor in chief at OSAlert.com, now a visual artist/filmmaker.
Follow me on Twitter @EugeniaLoli
Looks like the tool ist developed direct against specific databases
No way to configure a new db type (like DB2 UDB for expample).
Ralf.
DbVisualizer: http://www.minq.se/products/dbvis/ It’s a great product if you need multi-platform multi-db browsing/editing features.
Its a very nice app for executing sql queries, and browse the
server structure. Too bad there isn’t any support for anything else, like creating/deleteing tables,databases,columns and the like.
If you want to do that, you must execute the raw sql to e.g. create a new table.
SQL Editor is an explorer-type tool for MS SQL Server databases. Includes many useful features such as Object Expansion (shows dependencies), Search (find objects containing text), Object History (see and compare previous versions).
See http://www.sqleditor.com for further info.
“DbVisualizer: http://www.minq.se/products/dbvis/ It’s a great product if you need multi-platform multi-db browsing/editing features.”
Not as nice and powerfull as DbVisualizer, but SQuirreL SQL Client have the advantage of proposing the source code :
http://squirrel-sql.sourceforge.net/
I hope they put in some useful commands like adding/deleting tables, importation of data and such. That would be really neat and make it more functional (especially since it is cross platform).
When you think about it, the app is already opening up the database and there aren’t too many steps to adding tables or such visually. Just have to rely upon good old sql language until then.
Bill
Not much else to say really
Another example is jfacedbc which also works as an Eclipse plugin.
http://jfacedbc.sourceforge.net/
Rely good, you can manage your mysql and sql db in the same window, with good option like: easy access to the favorit script & the possibility of many query analyser window.
I love it
just.. I havn’t manage to install it on linux yet… to difficult to install for me (newbie) and no help doc