DbVisualizer

Software Screenshot:
DbVisualizer
Software Details:
Version: 9.1.6
Upload Date: 17 Feb 15
Developer: Roger Bjarevall
Distribution Type: Shareware
Price: 79.00 $
Downloads: 13

Rating: nan/5 (Total Votes: 0)

DbVisualizer project is a comercial and cross-platform database software designed for all major relational databases.

DbVisualizer enables simultaneous connections to many different databases through JDBC drivers.

What is new in this release:

  • Enhancement:
  • DB Support: Sybase ASE: Add support for UNICHAR/UNIVARCHAR size in DDL
  • General: Support user.vmoptions and modifying Java properties in Tool Properties for all installer types
  • Grid Component: Should be possible to copy/paste external files to binary/BLOB and CLOB grid cells
  • Grid Component: Should be possible to copy/paste binary/BLOB and CLOB data between grids
  • SQL Commander: Clicking on an icon for an error in the Log tab should move the caret to the error instead of selecting the statement
  • Workspace: Adjust active tab stripe color based on current look and feel. Allow override it in tool properties
  • Bug:
  • Connection Setup: Set Database Type to Auto Detect by default when using the Connection Wizard
  • Connection Setup: Pressing Tab in the Database Userid field in the Connection Wizard selects the value instead of moving to the next field
  • Database Objects Tree: Using any of the "Script..." or "Open in..." right-click options in the Tables grid with the Generic database type will result in an exception if TABLE_SCHEM is null
  • General: Occasional "Comparison method violates its general contract" error may be reported
  • Grid Component: Right double-click in the row number field without having a grid selection results in an exception
  • OS Support: Mac OS X: com.jidesoft.plaf.aqua.AquaPreferences loadGlobalPreferences may be listed in the debug window on OS X
  • SQL Commander: Highlighting errors for huge statements takes a very long time
  • SQL Commander: Sometimes the Elapsed Time field in the Log tab shows an incorrect value and the script may be executed multiple times
  • SQL Commander: Connection drops while executing in the SQL Commander require a manual reconnect rather than automatically at next execute
  • SQL Editor: Occasionally an error (NullPointerException in AttributedString) is triggered by various editor operations, e.g. the Find and Replace dialogs or simply double-clicking
  • Table Data Editor: Null cells should be preserved when copy/paste between grids independent what "Show Null As" is set to
  • Workspace: Exception: IndexOutOfBoundsException while closing or move tab
  • Workspace: Tab text color is too bright and "Show Tab Title in Bold" doesn't work with Metal L&F

What is new in version 9.1.5:

  • Enhancement:
  • SQL Commander - Present a Reconnect dialog when detecting a dropped connection at Execute
  • Bug:
  • SQL Commander - Having "Process Parameter Markers in SQL" enabled may consume cursors and cause following SQLs to fail during execution
  • Table Data Editor - Result set is not editable if using a sub query in the select statement

What is new in version 9.1.4:

  • Enhancement:
  • SQL Commander: SQL Commander->Strip Comments when Executing should be unchecked by default (for new users. Existing users need to uncheck manually)
  • SQL Commander: Add key binding to move focus between SQL editor and the result sets (View menu)
  • [http://www.dbvis.com/forum/thread.jspa?threadID=4705 ]
  • Tool Properties: Don't insert "save at" timestamp in the settings XML files
  • [http://www.dbvis.com/forum/thread.jspa?threadID=4731 ]
  • Workspace: Add key binding to activate and focus current workspace tab (Object View or SQL Commander)
  • Workspace: Focus is not set when using key binding to switch to Database, Scripts and Favorite tabs
  • Bug:
  • Connection Setup: Clicking the Ping button may result in an IndexOutOfBoundsException
  • DB Support - Other: Indexes doesn't show in the Indexes tab for a table for Progress databases
  • Data tab: While Data tab is being loaded (or saved) some controls are enabled that may result in an error due to the processing state
  • Database Objects Tree: Using keyboard to paste into the Databases tab list show an exception
  • General: An error may occur when connecting with the bundled Java VM: "Unsupported ccsid, encoding, or locale: "Cpxxx""
  • SQL Commander: Getting column information for unqualified tables fails for some databases, affecting Auto Complete and enabling of editing controls for result sets
  • [http://www.dbvis.com/forum/thread.jspa?threadID=4729 ]
  • Table Data Editor: Saving table data may give an error if saving to a table in non default schema
  • [http://www.dbvis.com/forum/thread.jspa?messageID=17324 ]
  • Table Data Editor: Pressing tab or enter key in a cell that contain newline or tab characters should not start the inline editor

What is new in version 9.1.3:

  • Enhancement:
  • Check for Update: Show underlying error message when not being able to connect
  • Data tab: Should be possible to assign key binding to the "Show in Navigator" action in the Data tab
  • General: Show underlying error message when not being able to connect for Pro evaluation
  • General: It should be possible to modify vmoptions per user and not only for the installation which may be shared by many users
  • Import: Dropping a file on a Tables or Table object should open the Table Data Import feature
  • Installation/Update Installation: Changes in the vmoptions file should survive when installing new versions
  • Workspace: Add option to set that "Open in Tab" should switch to the already open object tab first, otherwise open a new tab
  • Bug:
  • Check for Update: Use System Proxy Settings does not work on Windows if an automatic configuration script is used for system setting
  • Connection Setup: Disconnect All may take a while if having a lot (100+) of database connections
  • DB Support: Oracle: Max Size is not summarized correctly (DBA Views->Storage->Tablespaces) if having multiple data file for a tablespace
  • DB Support: SQL Server: Size parameter is not included in DDL for VARBINARY column and the MAX value is not supported for VARBINARY in Create/Alter Table
  • Database Objects Tree: Using the pre 9.0 scripting features doesn't honor the scripting settings in connection properties
  • Database Objects Tree: It is not possible to connect (using the node expand handle) a database connection in the Databases tab if it is in an error state
  • Database Profile: Actions: The Drop Table action doesn't generate good SQL for MaxDB
  • Driver Manager: De-selecting a driver jar file doesn't disable the command buttons. Invoking these without an active selection may result in an error
  • Grid Component: Clicking 'Reset Columns' button in the Grid Column Chooser while the underlying resultset is being loaded results in an error
  • Monitor: Reloading monitor scripts will reset the current results of any active monitors
  • Monitor: Re-displaying the monitor window with monitors running may display an empty dialog in front of it
  • Query Builder: Missing whitespace between an operator and its expression cause an error when loading a SELECT statement
  • SQL Commander: Getting column info for a result set fails if the table identifier is qualified with a different database than the default
  • SQL Commander: Executing queries for large tables with Sybase IQ may be dramatically slower than versions older than 9.0.5
  • SQL Commander: NullPointerException when executing a script containing an error with Preprocess Script disabled for databases that support error highlighting
  • SQL Commander: When executing a script for a connection that has dropped, an error is reported for the first statement but a new connection is acquired and the rest are executed, possibly with the default database/schema instead of the selected
  • SQL Formatter: Formatting a "WITH tableName -- comment AS (SELECT ..." statement does not work as intended
  • SQL Formatter: Variables for non-literal strings are mangled when using the Add One Space whitespace setting for the SQL Formatter
  • Table Data Editor: Paste in row form editor doesn't work
  • Tool Properties: Setting the "Show Null Value as" to en empty string in Tool Properties->Data Formats will break the scripting and table data editing features

What is new in version 9.1:

  • The ability to locate SQL script errors was added. Java 7 is now supported on Mac OS X,.
  • Database type is now auto-detected.
  • Native explain plan support was provided for PostgreSQL.
  • The on-line documentation is now organized after how you work, not how DbVisualizer is structured.
  • Version control and upgrading is done from inside DbVisualizer - you request trial licenses, get prompted when new versions are available, and are notified when your license is about to run out.

What is new in version 9.0.4:

  • 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 is new in version 9.0:

  • 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 is new in version 8.0.2:

  • 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 is new in version 8.0:

  • 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.

Requirements:

  • Java 2 Standard Edition Runtime Environment

Similar Software

indigestion
indigestion

20 Feb 15

conrad
conrad

11 May 15

PgAdmin III
PgAdmin III

17 Feb 15

Comments to DbVisualizer

Comments not found
Add Comment
Turn on images!