DbVisualizer 9.0.4 - Changelog

What's new in DbVisualizer 9.0.4:

February 19th, 2013

ENHANCEMENTS:
· Compare: Allow comparison of similar data types, e.g. Integer and BigDecimal
· [http://www.dbvis.com/forum/thread.jspa?threadID=4336 ]
· Compare: Center the current difference vertically when navigating between them
· Create/Alter Table: Create/Alter Table window need to be larger and optimize column sizes
· DB Support: MySQL: Order procedures and triggers by name in the objects tree
· DB Support: SQL Server: Remove dependency on SQL Server 2000 compatibility views in the DDL generator and the profile queries
· Database Objects Tree: Support re-arranging multiple database connections and folders using drag and drop
· Database Profile: Actions: The Create Trigger action should support setting multiple trigger events (INSERT, UPDATE, DELETE)
· Favorites: Favorites editor and the favorites bar should support adding multiple objects at once
· [http://www.dbvis.com/forum/thread.jspa?threadID=4350 ]
· Favorites: Support re-arranging multiple favorites and folders using drag and drop
· Grid Component: Add an entry for the Column Chooser in the grid header right-click menu (is currently only available as a button above the vertical scrollbar)
· Grid Component: Add "Inverse Selection" action in grid right-click menu
· [http://www.dbvis.com/forum/thread.jspa?messageID=15826 ]
· Performance/Stability: Improve performance for getting column information in most cases, e.g. when deciding if a result set should be editable
· Query Builder: Should be possible to remove all joins for a specific table (i.e. right-click in table node and select "Remove All Joins")
· SQL Commander: Add a "Load SQL in New Editor" to result set tab right-click menu and log icon
· [http://www.dbvis.com/forum/post!reply.jspa?messageID=15852 ]
· SQL Editor: Do not move the caret and scroll positions when doing Replace All
· SQL Editor: Up and Down arrow keys should move caret to beginning/end when on first/last line
· SQL History: Opening a history entry from the SQL History editor should make the main window active
· [http://www.dbvis.com/forum/thread.jspa?threadID=4273 ]

BUGS:
· Compare: Flip may cause an error (NullPointerException)
· DB Support: PostgreSQL: Data types with "WITH/WITHOUT TIME ZONE" and declared precision are not handled correctly in Create/Alter Table
· Favorites: The "Add to Favorites" window should only display folder objects in the Favorites list
· Grid Component: The coloring of XML data in the XML Viewer makes it difficult to read when rows are selected
· Monitor: Changing series while auto reloader is running may clear all active series
· [http://www.dbvis.com/forum/thread.jspa?threadID=4349 ]
· SQL Commander: Passing both -connection and -sqlfile arguments doesn't set the connection in the SQL Commander loaded with the file
· [http://www.dbvis.com/forum/thread.jspa?messageID=15854 ]
· SQL Commander: Recognize WITH as a SELECT in the execution permission control

What's new in DbVisualizer 9.0:

December 4th, 2012

· This version has a revised user interface with a cleaner design and a more flexible and productive way of working, as well as more room to work.
· It is easier to work with multiple database objects.
· Customized layouts are saved between sessions.
· Compare editors and grids, a new look and feel, minimized risk of lost edits, minimized problems with slow or dropped connections, and much more.

What's new in DbVisualizer 8.0.2:

August 8th, 2011

· Navigator
· Handle large list of Related Tables in a better way, e.g. make the list scrollable
· [http://www.dbvis.com/forum/thread.jspa?threadID=3594 ]
· SQL Editor
· Restore the 7.1 behavior for Insertion Point to End of Line
· [http://www.dbvis.com/forum/thread.jspa?messageID=12788 ]
· SQL Editor
· Add option to show non-printable characters (tab, whitespace, etc) in the editor
· [http://www.dbvis.com/forum/thread.jspa?messageID=12581 ]
· Table Data Editor
· Table data editor need to save edits in the following order: 1) deletes, 2) updates, 3) inserts to prevent triggering constraint rules
· [http://www.dbvis.com/forum/thread.jspa?threadID=3588 ]
· Bug
· Chart
· Range of Y-axis is erroneous if the max value in a serie is negative
· Database Objects Tree
· The objects tree right click menu may render some actions as disabled
· [http://www.dbvis.com/forum/thread.jspa?messageID=12868 ]
· DB Support: PostgreSQL
· Select composite type column gives exception
· DB Support: PostgreSQL
· Exception or incomplete info when getting column info for DDL
· DB Support: SQL Server
· The default schema cannot be determined for some database configurations
· [http://www.dbvis.com/forum/thread.jspa?messageID=12827 ]
· References
· Not possible to open references graph GML files in yED
· References
· A NullPointerException occur when exporting references graph in SVG or PDF formats
· SQL Editor
· Selection not cleared by Move Caret o Next/Previous Word
· [http://www.dbvis.com/forum/thread.jspa?messageID=12563 ]
· SQL Editor
· Triple-clicking a line to select it and then extending the selection by dragging the mouse down deselects the first line
· SQL Editor
· Delete Line clears all text but does not remove the line break
· [http://www.dbvis.com/forum/thread.jspa?threadID=3564 ]
· SQL Editor
· The action for moving/selecting to the previous word places the caret at the end of the target word instead of at the beginning
· [http://www.dbvis.com/forum/thread.jspa?threadID=3487 ]
· SQL Editor
· The statement parsing is off if a file containing CR linefeeds is loaded in to the editor
· [http://www.dbvis.com/forum/thread.jspa?threadID=3420 ]
· SQL Editor
· "Invalid location" warning when deleting all text as the first edit action
· SQL Editor
· The caret placement may be off when the font specified in the settings file does not exist on the current platform
· [http://www.dbvis.com/forum/thread.jspa?threadID=3585 ]
· SQL Editor
· Copy of multiple lines and pasting them over the selection may lose indentation
· [http://www.dbvis.com/forum/thread.jspa?threadID=3493 ]
· SQL Editor
· Horizontal scroll with wheel/trackpad scrolls vertically
· [http://www.dbvis.com/forum/thread.jspa?threadID=3468 ]
· SQL Editor
· Extending the selection by dragging the mouse up in the row number area stops suddenly
· SQL Editor
· The action for moving/selecting to the previous word places the caret one character to the left of the target when caret is at the beginning of a line
· [http://www.dbvis.com/forum/thread.jspa?threadID=3462 ]
· Table Data Editor
· After saving in data editor, edited cells may still show old value
· [http://www.dbvis.com/forum/thread.jspa?threadID=3574 ]
· Table Data Editor
· While saving in the data editor, edited cells flicker and show the old value
· [http://www.dbvis.com/forum/thread.jspa?threadID=3574 ]
· Table Data Editor
· Fix so that when editing a cell value (for duplicated rows) to the same value it currently have, should preserve the edited state
· [http://www.dbvis.com/forum/thread.jspa?messageID=12961 ]

What's new in DbVisualizer 8.0:

June 19th, 2011

· This version added support for the popular SQLite and H2 databases, integrated SSH tunneling, a new SQL editor with extended style configuration and database specific keyword support, enhanced chart support with pre-defined color schemes and easy setup, and the ability to export results in Excel 2007 and column formats.

What's new in DbVisualizer 7.1.4:

November 24th, 2010

Improvement:
· Change the variable delimiters in Connection setup details from $$...$$ to the same used in SQL Commander (default ${...}$)
· Format the numbers in execution result counters in the progress information area
· 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 = "" 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
· DB Support: Sybase ASE - 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
· DDL Generator - 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
· Export - When exporting a table with BIT data, the BIT values are quoted in the INSERT statement [http://www.dbvis.com/forum/thread.jspa?messageID=11501]
· Export - The exportsettings.xml/exportschemasettings.xml files may be empty resulting in an XML error when exporting [http://www.dbvis.com/forum/thread.jspa?messageID=11702]
· 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
· SQL Commander - Whitespace should be ignored after the block end delimiter
· SQL Commander - 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)

What's new in DbVisualizer 7.1.3:

September 13th, 2010

Improvement:
· DB Support: DB2 LUW
· Add support for dropping columns in Alter Table for database version 9 or later
· [http://www.dbvis.com/forum/thread.jspa?messageID=11522]
· References
· Reload in References graph should reload from the database rather than just layout the cached tables in the graph
· [http://www.dbvis.com/forum/thread.jspa?threadID=3263]

Bug:
· 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

What's new in DbVisualizer 7.1.2:

August 22nd, 2010

Improvement:
· 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

Bug:
· 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
· [http://www.dbvis.com/forum/thread.jspa?messageID=11435]
· DB Support: MySQL
· Data type names are converted to uppercase in DDL, including the parameters for ENUM and SET types
· [http://www.dbvis.com/forum/thread.jspa?threadID=3225]
· DB Support: PostgreSQL
· The COMMENT statements in the DDL for a PostgreSQL table may reference incorrect columns if a column has been dropped
· [http://www.dbvis.com/forum/thread.jspa?threadID=3224]
· 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
· [http://www.dbvis.com/forum/thread.jspa?threadID=3215]
· Export
· DROP statements are not generated for code objects (procedures, functions, etc.) for some databases when Create DROP Statements is enabled
· Export
· Using multiple "@export set" commands in a script resets the Filename
· [http://www.dbvis.com/forum/thread.jspa?threadID=3226]
· General
· The "You need to re-connect..." error window may appear while exiting DbVisualizer
· [http://www.dbvis.com/forum/thread.jspa?messageID=11446]
· Navigator
· Incorrect grid data shown when sorting the source table before navigating to the target table
· [http://www.dbvis.com/forum/thread.jspa?threadID=3222]
· SQL Commander
· When using Anonymous SQL Blocks in a script executed with the @run command, the end delimiter is included in the statement
· SQL Commander
· Clicking Stop may result in a stack trace in the Debug window
· SQL Commander
· 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
· [http://www.dbvis.com/forum/thread.jspa?threadID=3227]

What's new in DbVisualizer 7.1.1:

June 29th, 2010

· 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

What's new in DbVisualizer 7.1:

June 22nd, 2010

General:

· Improved integration with Windows and Mac OS X enable opening SQL files in new DbVisualizer editors rather than opening new instances of DbVisualizer

Database Support:

· Support for Informix 11.5
· Support for IDENTITY columns and ENUM and SET in Create/Alter Table

Driver Management:

· Automatic upgrade of bundled JDBC drivers when installing new DbVisualizer version

Grid:

· New PDF viewer for Binary/BLOB data types
· Configurable grid colors allows changing all colors that are used to highlight various states
· Copy/Paste and Drag & Drop of Binary/BLOB data
· Find Column feature which will scroll to the matched column name
· Sorting improvements such as keep sorting when quick filtering, reload result set from database with current grid sorting as ORDER BY

SQL Commander:

· New @run client side command for execution of script file (supports parameters as arguments)
· New @beep client side command
· Default display mode can now be set to any of Grid (default), Text or Chart