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 7.1

Select version

Release Notes

Bugs Fixed

  • Data tab Decimal number precision may be cleared if using another Decimal Format than "Unformatted" and the formatting rules for the current locale use a "," as decimal separator
  • Export Exception thrown when exporting table data with a driver that does not provide schema/catalog info, such as the Transoft driver
  • General Having Tool Properties->General->Table Data->Show Table Row Count enabled may lock the GUI if two or more main windows are displayed
  • Grid Component The auto column width formatter sometimes truncate columns showing "..." at the end cell
  • SQL Editor SQL editors may lose sync with what file is being loaded and what file is reported in the editor title
    See the discussion here

Improvements

  • Connection Setup Change the variable delimiters in Connection setup details from $$...$$ to the same used in SQL Commander (default ${...}$)
    See the discussion here
  • SQL Commander Format the numbers in execution result counters in the progress information area

Bugs Fixed

  • Connection Setup Jumping between two database connections with the same URL may accidentally modify the second connections URL if editing the URL in the first connection
  • DB Support: DB2 LUW Explain plan can only be performed with EXPLAIN_xxx tables being stored in the login schema even if using "set current sqlid = "<anotherschema>" as connection hook
  • DB Support: Informix The DBA keyword is missing in the source loaded into the source editor for procedures and functions
  • DB Support: JavaDB/Derby Exporting indexes for a table fails with Derby 10.6
  • DB Support: Oracle Explain Plan in Oracle present less information than in versions prior to 7.1
  • DB Support: SQL Server Opening the Groups node with SQL Server 2008 or newer gives an error
  • DB Support: Sybase ASE The DDL shown or exported for a large view declaration may have text segments out of order
  • Procedure is shown twice in the Object Type list in the Object Filter section
  • DDL Generator Precision and scale are not included in DDL type declaration for decimal data types when using the Generic profile
  • The DROP INDEX syntax is incorrect for some databases
  • Export DROP statements should not be generated for indexes, since they are dropped when the table is dropped
  • When exporting a table with BIT data, the BIT values are quoted in the INSERT statement
    See the discussion here
  • The exportsettings.xml/exportschemasettings.xml files may be empty resulting in an XML error when exporting
    See the discussion here
  • Installation The 64-bit Windows installer may download a 32-bit Java VM which will result in errors
    See the discussion here
  • Key Bindings Control+S may switch to Database Search if using the key binding to save an already saved SQL editor
  • References Showing table references for a specific table results in an error if doing a Reload
  • SQL Commander Preprocessing of a script larger than 5 MB fails
  • Whitespace should be ignored after the block end delimiter
  • The Elapsed Time counter is not running when parsing and executing large scripts without preprocessing
  • Workspace Default file encoding is not considered when opening a SQL file in the OS environment (with for ex. Windows Explorer or OS X Finder)

Improvements

  • DB Support: DB2 LUW Add support for dropping columns in Alter Table for database version 9 or later
    See the discussion here
  • References Reload in References graph should reload from the database rather than just layout the cached tables in the graph
    See the discussion here

Bugs Fixed

  • DB Support: Sybase ASE Calling sp_procxmode to preserve the mode in versions prior to 15 cause various problems, so do not try to preserve the mode in older versions
  • Import NullPointerException may occur if selecting "Map by Column Name" or "Map File Data Type = Table Data Type"
  • References Press "All Tables" or "Specified Tables" in the References graph after doing reload in the objects tree results in an error
  • SQL Commander Copy in the SQL Commander log should only copy the selected text rather than all of the log

Improvements

  • DB Support: Oracle Improve the support for Program, Replication, ASM, AWR, Scheduler, Resource Groups, DataGuard and Streams object types
  • Procedure Editor Show the same error message for a lost connection when selecting a procedure as is shown when selecting a table
  • Tool Properties The Permission confirmation window should show number of SQLs that are affected for each permission level

Bugs Fixed

  • Connection Setup Connection variables may be lost if DbVisualizer is abruptly exited
  • DB Support: DB2 LUW The "Empty Table" action to truncate a table don't work if not using DB2 9.7 and later
    See the discussion here
  • DB Support: MySQL Data type names are converted to uppercase in DDL, including the parameters for ENUM and SET types
    See the discussion here
  • DB Support: PostgreSQL The COMMENT statements in the DDL for a PostgreSQL table may reference incorrect columns if a column has been dropped
    See the discussion here
  • DDL Generator Incorrect table reference in FK constraint when the referenced table is in another catalog/schema than the referencing table
  • Explain Plan Oracle/DB2 LUW: Changing schema with the Schema drop down and then run Execute Explain will not set the new schema in the database
    See the discussion here
  • Export DROP statements are not generated for code objects (procedures, functions, etc.) for some databases when Create DROP Statements is enabled
  • Using multiple "@export set" commands in a script resets the Filename
    See the discussion here
  • General The "You need to re-connect..." error window may appear while exiting DbVisualizer
    See the discussion here
  • Navigator Incorrect grid data shown when sorting the source table before navigating to the target table
    See the discussion here
  • SQL Commander When using Anonymous SQL Blocks in a script executed with the @run command, the end delimiter is included in the statement
  • Clicking Stop may result in a stack trace in the Debug window
  • Client-side command syntax errors displayed as generic exceptions with stack trace in log
  • SQL Editor Must be possible to turn of the "save changes" confirmation when jumping in the history
    See the discussion here

Bugs Fixed

  • Check for Update Check for Update shows that Free Upgrade is available when it is really not a free upgrade
  • Data tab An error may appear when viewing the Data tab containing BLOB/Binary data
  • OS Support: Windows Error starting second instance of DbVisualizer on Windows, "Cannot run program "dbvis-multi.exe": CreateProcess error=2, The system cannot find the file specified"
    See the discussion here

New Features

  • DB Support: Informix Verify DbVisualizer with Informix 11.5
  • DB Support: MySQL Add Create and Drop User actions
    See the discussion here
  • DB Support: Oracle Add Create and Drop Role actions
  • DB Support: Sybase ASE Add Create Function action
  • Add Drop and Script CALL to Editor actions for Function objects
  • Add support for User Defined Functions
  • Driver Manager The Driver Finder should always run when launching a new DbVisualizer version
    See the discussion here
  • 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
    See the discussion here
  • Add "Reload with Column Sorting as Sorting Filter" right click menu command in the Data tab
  • Add a viewer for PDF documents
  • Add option to treat number values in text data types as numbers in the "Aggregation Data for Selection" feature
    See the discussion here
  • Allow custom colors for quick filter match, nulls, notifications and editing in the grid component
    See the discussion here
  • SQL Commander New client side command: @run <script> <var1> <var2>
  • Add a File->Revert to Saved command to revert all changes made to a SQL file
    See the discussion here
  • Add audio notification capability in the SQL Commander
    See the discussion here
  • 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
    See the discussion here

Improvements

  • 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)
  • Add support for the ENUM and SET data types in the Create/Alter Table dialogs
  • Allow auto completion in the Data Type column
  • Data tab "Script: DELETE WHERE" should accept a multi row selection
  • Make it possible to set number of max table data filters
  • 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"
    See the discussion here
  • DB Support: DB2 LUW Add support for START WITH and INCREMENT BY for IDENTITY columns in DDL
  • Add "Indexes" child node for Materialized Query Tables
    See the discussion here
  • 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
    See the discussion here
  • 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
  • Show table indexes in the objects tree for each database
    See the discussion here
  • 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
  • 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
  • Copy/paste of binary data should be supported
  • Preserve selection when sorting grid
  • Preserve sorting in grid when quick filter is activated
  • Should be possible to configure whether the Max Rows warning should appear automatically or not
  • Procedure Editor Keep cursor position when clicking Save
    See the discussion here
  • SQL Commander Add "Create New SQL Editor" button in the main toolbar
  • Add new "Default Display Mode" setting used to determine default display for result sets in the SQL Commander (one of Grid, Text, Chart)
  • File->Open should default to "Open in New Editor" rather in the current editor
    See the discussion here
  • If numbers are set to include thousand separators (,) in Tool Properties then these are also part of the generated SCRIPT: xxx SQLs
  • 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
  • Don't save duplicate entries in the SQL history for statements being executed in sequence
    See the discussion here
  • Tool Properties Export User Settings: Add option to convert all paths to be relative rather than absolute
    See the discussion here

Bugs Fixed

  • Database Objects Tree Long object filter pattern requires resizing of Objects Tree pane to access buttons for adding and removing filters
    See the discussion here
  • 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
  • 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

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