Download DbVisualizer 8.0.7

Publisher's description

DbVisualizer is a powerful tool for navigating JDBC-enabled databases.

Available Translations: None

Changes on the new version:
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