The latest major release of DbVisualizer is now available. It features many enhancements, fixes and some really interesting new functions. The following lists some of the highlights.

Please see the release notes for a detailed list of changes.

General

General improvements in this release.

  • The user interface has been polished
  • Installer now supports Mac OS X on Intel
  • SQL Server 2005 and Sybase 15 is now supported
  • Database connections can be categorized as DevelopmentTest or Production
  • The export feature supports Microsoft Excel and DbUnit (www.dbunit.org) XML formats
  • Support for BMP and TIFF image formats in the form editor and the new cell browser
  • The new grid cell browser is useful to quickly browse large column values
  • XML data can now be displayed in a tree format
4.0 objectsTree

Key Bindings

The key bindings editor has been totally rewritten and now allow modification of key bindings for all operations in DbVisualizer including editor keys

Key bindings are now set for all major actions and listed accordingly in menus and tool tips.

Pre-defined key maps for Windows, Linux/UNIX and MAC OS X. In addition there are key maps for easier transition for TOAD and SQL Query Analyzer users

4.0 objectsTree

Reference Graph

  • New option that will render relations between the actual columns in the tables
  • New operations to remove nodes, arcs and bends
  • Incremental auto layout when manually moving table nodes
4.0 objectsTree

SQL Commander enhancements

Each SQL editor now manage its own collection of result sets
New Load Recent menu lists the 20 last loaded SQL files
New editor commands:

  • Execute Buffer operation will execute all of the editor content as one statement. This can be used as an alternative to anonymous SQL block execution
  • Comment LineComment Block
  • Lower CaseUpper Case
  • Highlight current statement

The new Editor Controls pane now collects all controls used to define the characteristics of the execution, result set(s) and SQL log.

4.0 objectsTree

SQL Formatter

  • The new SQL Formatter formats your SQL's based on an extensive collection of settings
4.0 objectsTree
4.0 objectsTree

Explain Plan

  • Knowing the access path for your select statements is crucial for performance in any database application. The new explain plan support for OracleDB2 and SQL Server encapsulates the plan functionality provided by these databases nicely in DbVisualizer. Just execute the select statement and browse the plan. Using the pin feature you can refine and execute the statement over and over and easily compare the improvements of the plan.
4.0 objectsTree
4.0 objectsTree

Procedure Editor and Compiler

  • The stored procedure editor and compiler for (initially) Oracle allows editing and compilation of procedures, functions and packages.
4.0 objectsTree

To see all changes in DbVisualizer 5.0, please see the Release Notes.

Cookie policy

We use cookies to ensure that we give you the best experience on our website. However you can change your cookie settings at any time in your browser settings. Please find our cookie policy here ↗