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.
v10.0 [Sep 14, 2017]
Enhancement
Database Profile: Actions
DB Support: Vertica Add a Purge Table action for a table in Vertica
Export
Grid Component Add a "Open as Spreadsheet" in grids
Favorites Add shortcuts for Select Target Object in the Favorites toolbar (Alt click) and the Favorites tab (Alt double-click)
General Allow scaling UI more than 200%
SQL Commander Add a "Select Target Script File" in the SQL editor status bar filename right-click menu. Used to highlight any corresponding script file in the Scripts tab
Bug
Connection Setup ConcurrentModificationException when running "Connect and execute"
Connection Setup
DB Support: Informix When connecting to Informix "SQLWarning: Database Selected" is displayed at the top of the Connection Message
Database Objects Tree Dragging a table from the Databases tab to the query builder doesn't work if Autoscroll TO Object View tab is enabled
Database Objects Tree With "Autoscroll TO Object View Tab" enabled, do not autoscroll if right-click an object or when double-click set to Expand/Collapse Child Objects
Database Objects Tree A java.util.ConcurrentModificationException may occur while loading database objects tree if there are a lot of objects
Export Exporting time and date data is not thread safe
Grid Component Wrong datetime for dates before 1893-04-02
Grid Component If having a very large grid, select all cells and then reload, the reload takes long time to complete
Grid Component
OS Support: macOS Paste a multiline selection from Excel to a DbVisualizer grid only paste the first row
Import Potential exception when importing XLSX
Installation/Update Installation
OS Support: macOS The macOS menubar is not displayed when the Preferred OS Language is not English
Performance/Stability The OutOfMemory dialog is not as responsive as it should
Procedure Editor Closing Procedure Editor while compiling shows the "confirm close" dialog twice if clicking Keep Tab
SQL Commander Improve meaning of "Confirm unsaved SQL Commanders"
SQL Commander Potential NPE if closing the Procedure Editor while compiling
SQL Commander @delimiter command is not detected if preceded by a line comment
SQL Editor Triple-click in editor loses some of the selection if extending selection with shift-down
Tool Properties Formatting does not work for patterns following the millis pattern .SSS
Feature-rich relational database known for its high performance and excellent concurrency
Mall Creeps
