DbVisualizer is a very helpful tool for both administrators and developers, focused on database visualization and administration. The user is able to quickly connect, visualize details, explore the structure, execute SQL statements and perform many other operations on many database servers.
DbVisualizer uses JDBC drivers to establish connections to all major relational databases, including DB2 (Win/Linux), Informix IDS, JavaDB/Derby, MySQL, Oracle, PostgreSQL, SQL Server, Pervasive, SAP DB and more.
Moreover, thanks to the power and stability of Java environment and YFiles, an advanced visualization library, DbVisualizer can generate entity-relationship diagrams easily and very fast, choosing between different visualization modes (Hierarchic, Organic, Orthogonal, and Circular) and format options to show into the diagram (e.g. what content to show in each node: just the node name, node name with primary keys, or all the table fields) as well as graph controls like zoom, animation, bridge links, etc.
DbVisualizer requires Java VM 1.6 to use, and from the download page you can choose to download both the installer with Java VM included and the one without Java.
v8.0 [Jun 20, 2011]
Improvements :
- DB Support: Mimer SQL
Show error position in the SQL log when running a statement in SQL Commander
- Explain Plan
The node tooltip should be disabled while in the magnifying mode
- Grid Component
Allow using the SPACE key to select entries in editable cell lists
[http://www.dbvis.com/forum/thread.jspa?threadID=3504 ]
- Grid Component
Enable the hex viewer for any data type and not only binary/BLOB
- Grid Component
The read-only only cell viewer window should include the button to convert XML (and any other formatted views) to plain text
- Key Bindings
Command-W should close tab/internal windows rather than Commands-F4 when using OS X key map
- Table Data Editor
Column names specified in different case may result in table data editing being disabled
