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

  • General Restructured the main window menu bar:
  • Database menu now contains all operations that are used to control the database objects tree
  • Edit menu contains edit operations for the current SQL Editor
  • SQL contains all SQL related operations for the current SQL Editor
  • View menu contains general appearance operations
  • Key binding editor allowing full customization of all operations (including the SQL Editor. Several key bindings can be assigned to a single operation, each key binding can be composed of multiple key strokes. (Key binding now also appear in tool tips).
  • Installer now supports Mac OS X on Intel
  • SQL Commander Restructered the SQL Commander appearance to make it less cluttered
  • SQL Editor tool bar added with related operations
  • New Properties pane for the SQL Commander is used to control editor and the appearance. These were earlier available in the SQL Commander status bar.
  • New right click menu on the SQL Commander tab
  • New right click menu on the Editor tab
  • New right click menu on the Editor desktop (windows mode)
  • New right click menu on the Result Set tab
  • New right click menu on the Result Set desktop (windows mode)
  • Log properties now moved to right click menu
  • Result sets are now presented/managed per SQL Editor instead of globally for all SQL Editors.
  • New editor commands:
    • Comment Line
    • Comment Block
    • Lower Case
    • Upper Case
    • Select Current Statement
  • Execute Buffer (sends the complete editor buffer for execution as one statement)
  • SQL Formatter including a collection of properties used to control the formatter)
  • Explain Plan Explain Plan support for Oracle, DB2 and SQL Server added)
  • Oracle Support for object actions:
    • Table - Create, Drop, Rename, Copy, Comment, Truncate, Import Table Data, Script Object to SQL Editor
    • View - Drop, Rename, Compile, Comment, Script Object to SQL Editor
    • Synonym - Create, Drop
    • Index - Create, Drop, Rename, Rebuild, Compute Statistics
    • Sequence - Create, Drop, Rename
    • Materialized View - Drop
    • Function - Create, Drop, Compile
    • Procedure - Create, Drop, Compile
    • Package - Create, Drop, Compile
    • Package Body - Create, Drop, Compile
    • Trigger - Drop, Rename, Enable, Disable, Compile
    Oracle
  • Flashback to Before Drop, Purge from Recycle Bin
  • User
  • Create, Drop, Lock, Unlock, Change Password, Expire Password
  • Session
  • Kill Session
  • DB2 Support for object actions:
    • Schema- Create, Drop, Comment
    • Table - Create, Drop, Rename, Comment, Import Table Data, Script Object to SQL Editor
    • View - Drop, Comment, Script Object to SQL Editor
    • Alias - Create, Drop, Comment
    • Nickname - Drop, Comment, Script Object to SQL Editor
    • Index - Create, Drop, Rename, Comment
    • Materialized Query Table - Drop, Comment, Script Object to SQL Editor
    • Function - Drop
    • Stored Procedure - Drop
    • Package - Drop
    • Trigger - Drop, Comment
  • SQL Server Support for object actions:
    • Database - Rename
    • Table - Create, Drop, Rename, Import Table Data, Script Object to SQL Editor
    • View - Drop, Rename, Script Object to SQL Editor
    • Index - Create, Drop, Rename, Rebuild
    • Stored Procedure - Drop, Rename
    • Trigger - Drop
  • Mimer SQL Database profile with extended support for Mimer SQL
  • MySQL Support for object actions:
    • Database - Create, Drop
    • Table - Create, Drop, Rename, Import Table Data, Create Index,
      Script Object to SQL Editor
    • Process - Kill Session

Improvements

  • General Added Connection Properties for Database Connection Hooks.
    Use to specify commands that will be executed at database connect and disconnect (ex: session inits and database cleanups).
  • Removed borders for some tabbed panes to make the GUI less cluttered
  • All text fields now have a right click menu with common operations such as Cut, Copy, Paste, Delete and Select All
  • Key bindings now listed in the right click menus
  • Main tool bar commands for Execute, Execute Current, Previous History statement, Next History statement, Commit and Rollback moved to SQL Editor tool bar
  • Main window header now shows the name of the file loaded in the active SQL editor. (Listing of settings XML file is removed from main window header and instead listed in the Tool Properties).
  • Main Window and Monitor Window now preserve the window maximum state between invocations
  • Load Recent added to File menu. It lists the last loaded SQL files. (The limit setting can be modified in Tool Properties->SQL Editor).
  • Recommended file name extensions now listed in file choosers
  • Now possible to set a database connection to be any of Development, Test or Production. Depending on mode some features will be rendered differently to caught the attention of the user
  • Reconnect All added to Database main menu
  • Size and position of Tool Properties dialog now preserved between invocations.
  • Escape keyboard button can now be used to close all dialogs and windows that have no menu bar
  • Using Ctrl-W in application windows other then the main window closes the window (was previously Ctrl-Q)
  • Database Objects tree filtering feature re-designed.
  • Object tree filter now accepts the "*" wildcard character in addition to "%"
  • Support for drag & drop of nodes from the object tree to most input fields including the SQL Commander editor
  • Added support for "choices=" option in variables allowing list of choices in parameterized queries and connection settings
    See the discussion here
  • Database Objects Right click menu now only lists those operations valid for the currently selected node
  • Right click menu for table objects now contain Script Object to SQL Window
  • New Selected Object in the Database main menu now lists the valid operations for the currently selected node
  • The objects tree expansion state now preserved between reconnects
  • Fixed Connection Properties->Driver Properties and the way "Use" worked. "Use" has also been renamed to "Edited".
  • New connection property, Object Tree Labels.It is used to override how nodes will be named in the objects tree.
  • Data tab The Script: UPDATE WHERE now shows a dialog if the table have a primary key or at least one unique index asking whether the generated SQL should use the keys as the where clause or all selected values
  • Using IN operator in the Where Filter has changed. Text data is automatically quoted for the individual elements. Example: red,green,yellow -> 'red','green','yellow'
  • Data Editing Support to display TIFF and BMP image formats
  • Export Support for export in DbUnit XML formats
  • Support for export in Excel format
  • Import Skip Empty Rows now enabled by default
  • SQL Commander The log/result set is now automatically restored after execution if the editor was maximized (View->Show/Hide SQL Editor Ctrl-8)
  • File name of the active SQL Editor now listed in main window header
  • Variable dialog now executes when enter key is pressed in a field instead of adding a line break in the active field. (Use Shift-Enter to insert a line break).
  • Now possible to use $$ variables in files loaded with the @run client side command
  • The parameterization dialog now ignores variables with the noshow option
  • Number of Result Sets now listed in the Result Set tab header
  • Now possible to run anonymous SQL blocks in DbVisualizer Free
  • Now possible to run anonymous SQL blocks in DbVisualizer Free
  • Charts Show Point Labels setting added to chart settings. It will when enabled show X/Y value when hovering the mouse on a point in the chart
  • References Graph Enhanced graphing support with referenced columns being indicated in the graph
  • Manual layout adjustments can now auto reroute edges between nodes
  • Enhanced rendering performance
  • Find feature added, used to search and higlight table nodes
  • References graph settings now saved between sessions
  • New option Bridge Links. Useful when links cross each other
  • Arcs/Edges renamed to Links in the references graph
  • Bookmark Editor Added Execute Bookmark in the Bookmarks menu
  • Added Copy to SQL Commander added in Bookmark Editor.
  • Changed behavior of Execute Bookmark. It now copies the bookmark into the SQL Commander and then executes it
  • Grid Support to browse cell value based on value type
  • BMP, GIF, JPG, TIFF, PNG
  • XML (as text or document tree)
  • ASCII
  • HEX
  • Formatting Output. Vänta... replaced with the more universal Formatting Output. Wait... ;-)
  • Formatting Output. Vänta... replaced with the more universal Formatting Output. Wait... ;-)
  • Oracle New DBMS Output tab in the SQL Commander that replaces the DBMS output previously being presented in the Log tab.
  • "Dependencies" tab added to the object views
  • No need to execute "@set serveroutput on" in the same script as the dbms_output.put_line being executed anymore
  • Now possible to see Tablespace Quota for a user
  • Now possible to see what users have Tablespace Quota for a tablespace
  • Now possible to see Database Properties
  • Data Files now appear as child objects to tablespaces
  • List of tablespaces now show temp tablespaces + size
  • Tablespaces now appear as child objects to data files
  • Oracle 9.2 and later: DATE data type now handled and presented as Date in DbVisualizer. Former versions of Oracle handle DATE as TIMESTAMP
  • Oracle 10g: Recyle Bin tables now displayed in the Recycle Bin folder.
  • Columns now appear as child objects for tables in the database objects tree
  • Indexes now appear as child objects for tables in the database objects tree
  • Java Source and Java Class objects now listed in the objects tree
  • Roles tab now displayed when looking at a role in Oracle
  • Added Session Roles and Session Privileges to the Session Properties node in Oracle
  • New Database Connection property for Oracle: Handle DATE as TIMESTAMP
  • Selecting a Synonym in Oracle now show views (tabs) accordingly for the target object instead of only the generic Info tab
  • DB2 Summary Table is now Materialized Query Table
  • SQL Server Now with support for SQL Server 2005 + the new driver from Microsoft
  • MySQL Now possible to browse the source for Views (MySQL 5.0+)

Bugs Fixed

  • General Choosing "Copy" right click menu choice for multiple row cells in a grid erroneously added the new line identifier before the first value
  • Fixed installation problem
  • Database Objects Faster scrolling in the objects tree
  • Great improvements expanding tree objects having thousands of childs
  • Fixed a bug in the objects tree filter preventing multiple column filters to work
  • Enhanced performance showing object view when selecting an object in the objects tree
  • SQL Commander Executing update x set y='4----' where xid=12345; resulted in everything behind the first 4 to appear as comment.
  • The following comment was terminated at the / which it shouldn't /* a b c d e/f
    g h i j k
    */
  • Quoted data is now in red color
  • Issuing @export and then executing a non result set statement resulted in an error being reported in the log even though the exec were fine
  • It wasn't possible to enter special characters requiring the ALT key combination on Mac OS X. Some examples of chars that couldn't be typed were: @#[]{}.
  • Enhanced performance during rendering of the Text result set tab
  • References Graph Nothing happened when pressing Reload while tables were presented in "List" format
  • Grid Grid column header size now adjusts its height based on current font
  • SQL Server Triggers are now properly displayed for SQL Server
  • Informix Fixed minor bug in the profile for Informix resulting in an error if passing DELIMIDENT=Y as a connection property

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