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.

DbVisualizer 2.0

Select version

Release Notes

Improvements

  • It is now possible to specify whether numbers shall be formatted (in Tool Properties), i.e include thousand separators
  • CLOB/BLOB data is now displayed in the result of select statements
  • The max width of character data can now be specified in the Data tab and the SQL Commander. Any truncated columns are indicated with a red like color. (The main reason for this new "Max Chars" property is because of CLOB/BLOB data that might be very(!) big)
  • Now uses a new version of the installer (InstallAnywhere 4.0) which hopefully solves most of the reported installation problems.

Bugs Fixed

  • Decimal numbers displayed correctly
  • Big numbers are not rounded
  • Japanese characters can now be displayed correctly by adding the following property in the dbvis.lax file: dbvis.usegetobject=true
  • The references graph do not freeze or display dialogs if errors occur during fetch of the references information
  • The "Print Preview" dialog is now much faster and consumes less system resources
  • All columns in a grid are now printed correctly

Improvements

  • Important note:
    <dbvisualizer-install-directory>. Now it is stored in users "home" directory. "home" have different meaning depending on platform:
    • UNIX
      $HOME
    • Windows
      C:\Windows
    The name of the file is .dbvis.xml on UNIX and dbvis.xml on Windows and all other platforms. The exact name of the preferences file is now displayed in a pop-up dialog during start-up of DbVisualizer.
  • Support for print of graphs and tables! It is also possible to preview the actual pages before print.
  • The object browser tree now distinguish between procedures (may return results) and functions (do not return results).
  • Primary key column(s) are hi-lighted in Orange color everywhere it is appropriate ("Data" tab, "References" graph and in the substitute variable dialog).
  • It is now possible to preview the SQL statement in the variable substitution dialog.
  • Specify in tool properties whether visible tables (grids) shall auto fit the column widths or not. (Disabling this property speeds the rendering). Fit tables can be forced using the new pop-up menu in all grids.
  • New tab, "Catalogs" for a database node. A catalog is database specific and have different meanings for different databases. Catalogs do not exist in Oracle so in that case it is empty.
  • References graph related fixes Primary key columns are now hi-lighted in orange color in table nodes.
  • New tab "References" for a database node. It displays all tables and any relations between them for selected database.
  • "Columns" view do now display the order of all columns correctly as they were defined in the table. Previous versions ordered them randomly
  • New view "Primary Keys". Displays only table name and any primary keys in each table node.
  • New pop-up menu in all grids include operations for: Copy selected cells Copies the selected cells onto the clipboard using the column and new line delimiters as specified in tool properties
  • Select all cells Selects all cells in the grid
  • Fit column widths Forces a fit of all column widths so that each column get as wide as its widest value
  • Pop-up menu for the table "Data" tab is extended with the operations listed below. All of these menu choices except "insert into" requires that one row and at least one column is selected. (The selected cell values are used to build the where statement. If more cells are selected then they are AND'ed). Note: Selecting any of the menu choices will cause DbVisualizer to build the appropriate SQL statement and pass it to the SQL Commander tab.
    • select * where ...
      Builds a select all columns from the selected table and creates a where clause using the selected cell value(s). Ex:
      select * from User where Id = 212 and Name = 'olle'
    • select * where NOT ...
      Builds a select all columns from the selected table and creates a NOT where clause using the selected cell value(s). Ex:
      select * from User where Id != 212 and Name != 'olle'
    • insert into ...
      Builds an insert statement based on all columns in the current grid. Ex:
      insert into User ($Id||text$, $Name||text$)
      This operation will cause the substitution dialog to be displayed.
    • insert COPY into ...
      Builds an insert statement based on all columns in the current grid. The values of the selected row columns are set as default values in the insert statement. Ex:
      insert into User ($Id|212|text$, $Name|olle|text$)
      This operation will cause the substitution dialog to be displayed.
    • update where ...
      Builds an update statement for all columns in the grid using the selected cells in the where clause. Ex:
      update User set $Id|212|text$ and $Name||olle$ where Id = 212
      This operation will cause the substitution dialog to be displayed.
    • delete where ...
      Builds a delete statement using the selected cells to build the where statement. Ex:
      delete from User where Id = 212 and Name = 'olle'
  • Tool Properties dialog has changed into three tabs. Now includes a "SQL and Formatting" tab with SQL statements that are executed in the "Data" tab.
  • Now possible to specify whether SQL statement shall be exported into HTML or ASCII file. (Only enabled if SQL statement is known to DbVisualizer).
  • User preferences (XML) file is now stored when there is a reason for it. Previous versions stored the file only when exiting the tool properly.
  • The "Object Browser" now bolds each node that has been visited in the current session.
  • New function "Find" in status bar for the "Data" tab and SQL Commander. It can be used to search within the cells in the grid. Use Shift-Enter for backward search.
  • A database node is now removed using the "Database->Remove Database" instead of "Cut".
  • Null values are now represented in both exported files and in all grids. The string representing a null value can be set in tool properties. The color in any grid is always gray for null values.
  • "Transaction Isolation" can now be specified in tool properties. The selected isolation level will be applied for all current database sessions even though some database do not support a specific level. Watch the console window if you are uncertain if a level is supported for a specific database or not.

Bugs Fixed

  • Stored procedures are now displayed in the object browser tree for Sybase Adaptive Server Enterprise.
  • Improved rendering of grids
  • Grid column width was sometimes truncated and "..." was displayed.
  • Some columns reported data such as "[B@3136e5". Fixed by using the data type specific retrieval methods instead of getting all cell values as objects. The drawback however is that float and double might lose the precision since some drivers like the one from Oracle has its own way of dealing with it...

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