DbVisualizer

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.

Changes

• General
• Support 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-bars
• Support for Java 1.7
• Connection Management
• Integrated SSH support with trusted-host and private key support enabling connecting secure databases with a single-click.
• SQL Editor
• New SQL/text editor:
• SQL editor now support anti-aliased fonts
• Monospaced fonts automatically set based on platform: Consolas (Windows), Menlo (Max OS X), DejaVu (Linux/UNIX)
• Quick Search
• Support for Paste from clipboard history
• Support for database specific keyword highlighting
• Regular expressions in Find and Replace
• Show details for object at cursor
• Support to configure editor colors and text styles
• Support for text folding used to hide parts in the editor
• Macro recording and playback
• Charts
• Brand 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).
• Monitor
• New option to hide monitor toolbars
• Database Support
• Support for SQLite (bundled with DbVisualizer)
• Support for H2 (bundled with DbVisualizer)
• Explain Plan support for Mimer SQL
• Export
• Export DDL support for individual object types such as procedures, functions triggers, views, etc.
• Export in TXT format
• Support for export in Excel 2007 (OOXML) format in addition to the current binary Excel format.
• Grid
• Added "Copy Selection as Text (With Column Header)" in grids. Formats the selection in a fixed width output.
• Navigator
• The foreign key Navigator now support editing table data
• Added quick filter support in Navigator
• Jump directly from the Data tab to the Navigator with preserved selections, sorting etc.