Release NotesRelease Notes

Version Date
7.1.2 2010-08-18
7.1.1 2010-06-23
7.1 2010-06-16 W
7.0.8 2010-06-16
7.0.7 2010-05-25
7.0.6 2010-04-21
7.0.5 2010-03-16
7.0.4 2010-02-24
7.0.3 2010-02-23
7.0.2 2010-02-03
7.0.1 2010-01-29
7.0 2010-01-15 W P
6.5.12 2009-12-22
6.5.11 2009-12-05
6.5.10 2009-10-23
6.5.9 2009-08-29
6.5.8 2009-08-27
6.5.7 2009-06-19
6.5.6 2009-05-15
6.5.5 2009-04-06
6.5.4 2009-02-06
6.5.3 2009-01-12
6.5.2 2009-01-09
6.5.1 2008-11-23
6.5 2008-10-23 W P
6.0.15 2008-10-20
6.0.14 2008-09-22
6.0.13 2008-08-19
6.0.12 2008-06-26
6.0.11 2008-05-28
6.0.10 2008-04-10
6.0.9 2008-03-17
6.0.8 2008-02-24
6.0.7 2007-12-06
6.0.6 2007-10-15
6.0.5 2007-10-08
6.0.4 2007-09-25
6.0.3 2007-09-17
6.0.2 2007-07-25
6.0.1 2007-07-16
6.0 2007-07-09 W P
5.1.1 2006-10-16
5.1 2006-10-05 W P
5.0 2006-04-03 W P
4.3.6 2006-01-08
4.3.5 2005-10-06
4.3.4 2005-09-07
4.3.3 2005-08-19
4.3.2 2005-07-23
4.3.1 2005-07-05
4.3 2005-07-03 W P
4.2.2 2005-02-19
4.2.1 2005-02-11
4.2 2005-01-12 W P
4.1.1 2004-06-16
4.1 2004-04-06 W P
4.0.4 2004-01-20
4.0.3 2004-01-15
4.0.2 2003-11-07
4.0.1 2003-10-24
4.0 2003-10-22 W
3.3.1 2003-07-05
3.3 2003-06-07 W
3.2 2003-02-12 W
3.1.1 2002-12-09
3.1 2002-10-20 W
3.0 2002-07-01 W
2.1 2001-10-30
2.0.1 2001-05-18
2.0 2001-04-20
1.2.1 2000-12-23
1.2 2000-11-11
1.1 2000-06-05
1.0 1999-12-06

DbVisualizer 7.1 - Change Log

[ Change Log | What's New ]

New Feature

  • DB Support: Informix
    		• Verify DbVisualizer with Informix 11.5
  • DB Support: MySQL
    		• Add Create and Drop User actions
    [http://www.dbvis.com/forum/thread.jspa?threadID=3112]
  • DB Support: Oracle
    		• Add Create and Drop Role actions
  • DB Support: Sybase ASE
    		• Add Create Function action
  • DB Support: Sybase ASE
    		• Add Drop and Script CALL to Editor actions for Function objects
  • DB Support: Sybase ASE
    		• Add support for User Defined Functions
  • Driver Manager
    		• The Driver Finder should always run when launching a new DbVisualizer version
    [http://www.dbvis.com/forum/thread.jspa?threadID=2494]
  • Driver Manager
    		• When upgrading DbVisualizer version then automatically upgrade all bundled JDBC drivers
  • Grid Component
    		• Add "Find Column" feature which will automatically scroll horizontally to next column that match by name
    [http://www.dbvis.com/forum/thread.jspa?threadID=2627]
  • Grid Component
    		• Add "Reload with Column Sorting as Sorting Filter" right click menu command in the Data tab
  • Grid Component
    		• Add a viewer for PDF documents
  • Grid Component
    		• Add option to treat number values in text data types as numbers in the "Aggregation Data for Selection" feature
    [http://www.dbvis.com/forum/thread.jspa?threadID=2964]
  • Grid Component
    		• Allow custom colors for quick filter match, nulls, notifications and editing in the grid component
    [http://www.dbvis.com/forum/thread.jspa?messageID=10874]
  • SQL Commander
    		• New client side command: @run <script> <var1> <var2>
  • SQL Commander
    		• Add a File->Revert to Saved command to revert all changes made to a SQL file
    [http://www.dbvis.com/forum/thread.jspa?messageID=7577]
  • SQL Commander
    		• Add audio notification capability in the SQL Commander
    [http://www.dbvis.com/forum/thread.jspa?messageID=7938]
  • Workspace
    		• When opening an SQL file in for Windows Explorer or the Finder in OS X it should load the file in the currently running DbVisualizer instance rather than opening a new
    [http://www.dbvis.com/forum/thread.jspa?threadID=3051]

    Improvement

  • Connection Setup
    		• Select new database connection in the objects tree when created with the Connection Wizard
  • Create/Alter Table
    		• Add support for IDENTITY columns options (ALWAYS/BY DEFAULT, START WITH and INCREMENT BY)
  • Create/Alter Table
    		• Add support for the ENUM and SET data types in the Create/Alter Table dialogs
  • Create/Alter Table
    		• Allow auto completion in the Data Type column
  • Data tab
    		• "Script: DELETE WHERE" should accept a multi row selection
  • Data tab
    		• Make it possible to set number of max table data filters
  • Data tab
    		• The "Filter & Sort" right click menu should have an option to also consider current column sorting in the generated filter
  • Database Profile: View
    		• Make the Row Count tab "stoppable"
    [http://www.dbvis.com/forum/thread.jspa?messageID=6981]
  • DB Support: DB2 LUW
    		• Add support for START WITH and INCREMENT BY for IDENTITY columns in DDL
  • DB Support: DB2 LUW
    		• Add "Indexes" child node for Materialized Query Tables
    [http://www.dbvis.com/forum/thread.jspa?threadID=1954]
  • DB Support: JavaDB/Derby
    		• Add support for IDENTITY columns in DDL
  • DB Support: MySQL
    		• Add support for the "FULLTEXT" option in Create/Alter Table and Create Index dialogs
  • DB Support: Oracle
    		• Change the process for updating a CLOB/BLOB column via the data grid for 10g and later to stop UPDATE triggers from firing twice
    [http://www.dbvis.com/forum/thread.jspa?threadID=3014]
  • DB Support: Oracle
    		• Show execute permissions for stored procedures
  • DB Support: PostgreSQL
    		• Enable changing column data type in the Alter Table dialog for PostgreSQL 8
  • DB Support: SQL Server
    		• Add support for seed and increment parameters for IDENTITY columns in DDL
  • DB Support: Sybase ASE
    		• Add sp_procxmode call for procedure export DDL and maintain transaction mode in Procedure Editor
  • DB Support: Sybase ASE
    		• Show table indexes in the objects tree for each database
    [http://www.dbvis.com/forum/thread.jspa?messageID=5916]
  • Driver Manager
    		• An invalid driver definition (JAR file not found) should not have the same visible state as a driver that has not yet been configured
  • Driver Manager
    		• Drivers marked as invalid due to non existing driver jar files should be cleared when loading new jar files in the connection wizard
  • Export
    		• It should be possible to specify whether to qualify object names and use delimiters for Export
  • Favorites
    		• Favorite Editor: Add ALT+Double Click key binding for opening database object favorite in new window
  • Grid Component
    		• Add "Reset Sorting" command in the right click column header menu
  • Grid Component
    		• Copy/paste of binary data should be supported
  • Grid Component
    		• Preserve selection when sorting grid
  • Grid Component
    		• Preserve sorting in grid when quick filter is activated
  • Grid Component
    		• Should be possible to configure whether the Max Rows warning should appear automatically or not
  • Procedure Editor
    		• Keep cursor position when clicking Save
    [http://www.dbvis.com/forum/thread.jspa?threadID=3158]
  • SQL Commander
    		• Add "Create New SQL Editor" button in the main toolbar
  • SQL Commander
    		• Add new "Default Display Mode" setting used to determine default display for result sets in the SQL Commander (one of Grid, Text, Chart)
  • SQL Commander
    		• File->Open should default to "Open in New Editor" rather in the current editor
    [http://www.dbvis.com/forum/thread.jspa?messageID=7296]
  • SQL Commander
    		• If numbers are set to include thousand separators (,) in Tool Properties then these are also part of the generated SCRIPT: xxx SQLs
  • SQL Commander
    		• Preserve scroll position in the SQL Preview while editing values
  • SQL History
    		• Add setting to control whether failed SQLs should be saved in the SQL history
  • SQL History
    		• Don't save duplicate entries in the SQL history for statements being executed in sequence
    [http://www.dbvis.com/forum/thread.jspa?threadID=3099]
  • Tool Properties
    		• Export User Settings: Add option to convert all paths to be relative rather than absolute
    [http://www.dbvis.com/forum/thread.jspa?threadID=2815]

    Bug

  • Database Objects Tree
    		• Long object filter pattern requires resizing of Objects Tree pane to access buttons for adding and removing filters
    [http://www.dbvis.com/forum/thread.jspa?threadID=3139]
  • General
    		• An error may occur in various places when a SELECT with a sub query is used, such as when exporting the result of the query
  • General
    		• Opening a web browser from DbVisualizer may result in an error
  • SQL Commander
    		• Unexpected JDBC driver errors may freeze DbVisualizer while executing in SQL Commander