Try out DbVisualizer Pro for 21 days

Start the trial by running the latest version and then open the Evaluate Pro Edition under the Help menu.

Select version

Release Notes

New Features

  • New Features Driver Manager re-designed to primarily allow several versions of the same driver to exist simultaneously and concurrently Note: If you've been using a previous version of DbVisualizer then you will need to setup the drivers in the driver manager again. The internal structure of the driver definitions has changed so much that it is impossible to make the change backward compatible.

Improvements

  • Tool Properties Date/Time formats now accepts the format to be edited in Tool Properties. (Right Click menu lists all valid letters)
  • Added time format "hh:mm:ss.SSS"
  • "Remove New Lines" property re-introduced (it was removed in 4.0) but can now be specified per Database Connection (Properties). The reason having this property again is that creating for example procedures with explicit new lines would cause the procedure to be saved as one long unformatted line.
  • "Save Password" can now be specified per Database Connection (Properties).
  • JDBC Driver/Database Specific Added new object views for Oracle:
    • "Constraints" for tables
    • DBA->Statistics->Instance Summary
    • DBA->Statistics->Wait
    • DBA->Statistics->Latches
    • New DDL views for almost all objects. Shows the DDL to re-create the object
      Note: valid for 9i and later only
  • DB2's CHAR() FOR BIT DATA now presented as text and not binary
  • Now supports Progress OpenEdge 10+
  • References Graph Fix in the References Graph if erroneous or incomplete data returned from driver
  • NOT NULL columns indicated with bold column names in the references graph
  • SQL Commander Clicking the row header when at least one cell in that row was already selected did not select all cells.
  • Now supports all variants of "go, Go, gO, GO" as a statement separator in the SQL Commander
  • New result set output format, "Text" added to the SQL Commander. It shows in addition to the "Grid" and "Chart" formats the data in a tabbular style. Export is also supported. New Font setting for Text Output in Tool Properties.

Bugs Fixed

  • General Selecting the 5) column check box in the Connections overview did not update the state of the icon in column 2)
  • Sorting did not work properly in the Connections Overview
  • There was a memory problem when opening large BLOB/CLOB's in the Form Editor causing the application to freeze
  • CLOB viewer in the Form Editor did not handle font changes properly.
  • Connecting using JNDI lookup failed with an error
  • JDBC Driver/Database Specific DB2 applet server died suddenly. This fix hopefully solves it.
  • Getting table indexes in Oracle is now done in the database profile instead of using the JDBC driver. The reason is that the Oracle driver does an "analyze table" before getting indexes and that may result in side effects that are not wanted.
    Note: This applies only for DbVisualizer Personal. DbVisualizer Free still use the JDBC driver to fetch index information.
  • The fetch of synonyms for Oracle was wrong, "where owner = 'xxx'" instead of "where table_owner = 'xxx'"
  • DB2: The "Tables" tree object did not show any tables for the SYSIBM, SYSCAT, SYSFUN and SYSSTAT schemas.
  • DB2: The References Graph was empty for the SYSIBM, SYSCAT, SYSFUN and SYSSTAT schemas
  • Monitor Row Count and Row Count Change operations for Informix did not set the appropriate columns as series
  • References Graph "Show in Window" did not work properly in the References graph for PostgreSQL, SQL Server and Sybase
  • SQL Commander In DbVisualizer Free was only the first SQL statement in a script executed instead of all statements in a batch

New Features

  • Database Objects DbVisualizer Personal: "Database Profiles" introduced which enables database specific objects views in the Database Objects tree for Oracle, DB2, MySQL, Informix, SQL Server, PostgreSQL and SQL Server. A generic database profile is used if accesing any other databases or when using DbVisualizer Free.
  • DbVisualizer Personal: Now possible to search for objects by name in the Database Objects tree

Improvements

  • General Removed the capability to configure what columns to display in the old meta data tabs i.e Columns, Privileges, Primary Keys, etc. (Database Objects category in Tool Properties). A new generic filtering capability will be introduced in a future version.
  • The Dean S. Jones and Java Graphics icon collections has been removed. The reason is that these icon collections are to limited to express all new symbols required in 4.1.
  • Database Objects Setting a filter now applied to all places where the filtered objects are displayed. Filter can now also be controlled on all levels in the tree and not just only while the database connection object is selected.
  • Table Data Editing Data tab filter mode now respected when the grid is auto reloaded in the Data Form Editor
  • SQL Commander "Insert SQL into Editor" in SQL Commander result tab menus and output view menu inserts SQL at caret position
  • "Get Bookmark", "Execute" (bookmark editor), "Copy to SQL Commander" now copies the SQL into the current editor instead of primary editor

Bugs Fixed

  • General Sorting of grid text columns now sorts correctly i.e AaBbCc instead of ABCabc.
  • Table Data Editing Grid is now scrolled to the edited row or next row if "Auto Reload Grid" is checked in the Form Editor

Bugs Fixed

  • General Fixed OutOfMemory error when exporting to file
  • Fixed the error when starting DbVisualizer using Java 1.5 beta.
    Note: We do not recommend using Java 1.5 beta until DbVisualizer officially supports the final 1.5 version.
  • Changing variable identifier/delimiter sometimes damaged the SQL templates in Tool Properties.
  • Table Data Editing Edits for SQL Server now committed properly

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.

Close