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 it's still based on Java means its probably more functional and useful for Windows users than Mac users.
If you need something that supports multiple databases in one package DbVisualizer is a comprehensive package although it lacks some key features.
- Connection SetupEmbedded databases taking filename as part of the database URL should offer a file chooser in the connection setup (Server Info only) [http://www.dbvis.com/forum/thread.jspa?threadID=3550 ]
- Data tabThe "Max Rows at First Display" setting have effect only for the very first table data being displayed [http://www.dbvis.com/forum/thread.jspa?threadID=3538 ]
- DB Support: PostgreSQLException or incomplete info when getting column info for DDL
- ExportExport in XLS/XLSX format occasionally leave the exported file locked by DbVisualizer
- GeneralBrowsing the online documentation from the Help->Users Guide in DbVisualizer results in a 404 (Page not found) error
- ImportChanging Decimal Number Format in Tool Properties from Unformatted may lead to data truncation during import
- Performance/StabilityOccasional exceptions may appear at startup
- SQL CommanderRunning SQL blocks may result in error [http://www.dbvis.com/forum/thread.jspa?threadID=3558 ]
- SQL EditorChanging SQL Editor font is not preserved for the primary editor when re-starting DbVisualizer [http://www.dbvis.com/forum/thread.jspa?messageID=12756 ]
- SQL EditorWhen dropping a name into the SQL editor the position of the cursor is not moved after the name but stay at the drop position
- SQL FormatterThe Format SQL->Paste Formatted clear the editor and reset undo buffer while it should just paste at caret position and keep undo buffer
- SQL FormatterFormat SQL->Copy Formatted should operate on selection rather than whole buffer [http://www.dbvis.com/forum/thread.jspa?threadID=3407 ]