Show graphically JDBC databases

DbVisualizer is a cross-platform database tool that aims to increase user productivity. It offers a single solution to speed development, testing and administration of relational databases.

For developers, DbVisualizer offers a range of tools to assist database development and perform tasks such as object browsing, creating, running SQL statements and SQL scripts plus viewing and editing data.DbVisualizer is pretty powerful and it supports all major commercial databases including Oracle, DB2, Mimer, SQL Server, Sybase ASE, Informix and open source alternatives such as MySQL, PostgreSQL and JavaDB/Derby.

The first thing you’ll notice with DbVisualizer is that it takes ages to install. The installer has been designed with selling the product in mind so don’t be surprised to be prompted to purchase it before its even installed! There have been hundreds of little improvements to the latest version of DbVisualizer, including a new SQL editor, support for SQLite and new Excel export functions.

However, there are no such things as auto table completion and no SSH tunnel manager. The fact that its also still based on Java means its probably more functional and useful on Windows than on Mac so if you’re deciding which platform to install it on, go for Windows.

If you need something that supports multiple databases in one package DbVisualizer is a comprehensive package although it lacks some key features.

GeneralSupport drag and drop of bookmark, monitor and favorite files between DbVisualizer and external tools such as Windows Explorer, Finder (Mac) and File Browser (Linux)Screen estate adjustments and new controls to hide menu, tool and status-barsSupport for Java 1.7Connection ManagementIntegrated SSH support with trusted-host and private key support enabling connecting secure databases with a single-click.SQL EditorNew SQL/text editor:SQL editor now support anti-aliased fontsMonospaced fonts automatically set based on platform: Consolas (Windows), Menlo (Max OS X), DejaVu (Linux/UNIX)Quick SearchSupport for Paste from clipboard historySupport for database specific keyword highlightingRegular expressions in Find and ReplaceShow details for object at cursorSupport to configure editor colors and text stylesSupport for text folding used to hide parts in the editorMacro recording and playbackChartsBrand new chart component giving more appealing charts with pre-defined color schemes, gradient backgrounds and shadows.Now supports re-executing the query and preserving the chart configuration style (colors, fonts, etc).MonitorNew option to hide monitor toolbarsDatabase SupportSupport for SQLite (bundled with DbVisualizer)Support for H2 (bundled with DbVisualizer)Explain Plan support for Mimer SQLExportExport DDL support for individual object types such as procedures, functions triggers, views, etc.Export in TXT formatSupport for export in Excel 2007 (OOXML) format in addition to the current binary Excel format.GridAdded “Copy Selection as Text (With Column Header)” in grids. Formats the selection in a fixed width output.NavigatorThe foreign key Navigator now support editing table dataAdded quick filter support in NavigatorJump directly from the Data tab to the Navigator with preserved selections, sorting etc.

Changes

• GeneralSupport drag and drop of bookmark, monitor and favorite files between DbVisualizer and external tools such as Windows Explorer, Finder (Mac) and File Browser (Linux)Screen estate adjustments and new controls to hide menu, tool and status-barsSupport for Java 1.7Connection ManagementIntegrated SSH support with trusted-host and private key support enabling connecting secure databases with a single-click.SQL EditorNew SQL/text editor:SQL editor now support anti-aliased fontsMonospaced fonts automatically set based on platform: Consolas (Windows), Menlo (Max OS X), DejaVu (Linux/UNIX)Quick SearchSupport for Paste from clipboard historySupport for database specific keyword highlightingRegular expressions in Find and ReplaceShow details for object at cursorSupport to configure editor colors and text stylesSupport for text folding used to hide parts in the editorMacro recording and playbackChartsBrand new chart component giving more appealing charts with pre-defined color schemes, gradient backgrounds and shadows.Now supports re-executing the query and preserving the chart configuration style (colors, fonts, etc).MonitorNew option to hide monitor toolbarsDatabase SupportSupport for SQLite (bundled with DbVisualizer)Support for H2 (bundled with DbVisualizer)Explain Plan support for Mimer SQLExportExport DDL support for individual object types such as procedures, functions triggers, views, etc.Export in TXT formatSupport for export in Excel 2007 (OOXML) format in addition to the current binary Excel format.GridAdded “Copy Selection as Text (With Column Header)” in grids. Formats the selection in a fixed width output.NavigatorThe foreign key Navigator now support editing table dataAdded quick filter support in NavigatorJump directly from the Data tab to the Navigator with preserved selections, sorting etc.

DbVisualiser is the leading platform independent and cross database tool aimed to simplify database development and management for database administrators and developers.