Single database tool to access different database types?

Question

I’d like a visual database tool that will allow me to access multiple database types from the same program. I’m looking for anything that supports Mysql, PostgreSQL, and Derby. Anything else it supports is a bonus.

Answer 1

Perhaps DbVisualizer?

Answer 2

I think you might be interested in Sparx Enterprise Architect. It could help with reverse engineering and creating fancy diagrams. It works with everything you could get drivers for but your database are natively supported.

Vision for Enterprise Architects could do the same.

Answer 3

If you can get ODBC drivers for your databases (should be available from the DB vendor) you can use MS Access. If you want something free, I recommend SQuirrel SQL Client. It's implemented in Java, so you need JDBC drivers (usually also available for free) for each DB that you use.

Answer 4

I know very few who support Derby but they support MySQL, PostgreSQL, Firebird and others...

Check this :

• SQL maestro
• SQL Manager
• Database Workbench (not for PostgreSQL)
• Navicat

Answer 5

Check out AquaFold's Datastudio. It's written in Java, so it can access any DB that has a JDBC driver, and they offer free licenses to Open Source developers.

Answer 6

"SQL Anywhere" from Sybase.

Answer 7

RazorSQL supports PostgreSQL, MySQL, Derby, and a host of others. It is pretty cheap and has a ton of features, and I haven't found any other tools with better Derby support. For some reason, a lot of the other java based database guis don't support Derby very well.