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.

Select version

Release Notes

Improvements

  • DB Support: DB2 LUW Show Grants for Views
    See the discussion here
  • DB Support: Informix Add support for Informix 11 data types BIGINTEGER and BIGSERIAL in Create/Alter Table and DDL

Bugs Fixed

  • Auto Completion Typing a character hides the list rather than narrowing the list
  • Triggering auto-completion within a string literal like '..A' may cause a NullPointerException
  • DB Support: DB2 LUW Error showing DDL for tables in DB2 LUW version 10
  • DB Support: Oracle Random exception may occur while browsing certain database synonyms
  • DB Support: PostgreSQL Columns of type MONEY can not be shown or edited in a grid
  • DB Support: SQL Server Large triggers are listed multiple times under the table node and in the table -> Triggers view
    See the discussion here
  • Invoking a function returning a table with the @call command results in a syntax error
    See the discussion here
  • Export Exception when exporting result set after database connection has been disconnected
    See the discussion here
  • General The settings file (dbvis.xml) can sometimes be damaged when exiting DbVisualizer
    See the discussion here
  • SQL Editor Column auto-completion after a single period causes a StringIndexOutOfBoundsException
    See the discussion here
  • SQL Formatter DbVisualizer Variables should be left as-is by the formatter
    See the discussion here
  • Table Data Editor Table data editing fail if schema, catalog, table or column name contain $$
    See the discussion here

Improvements

  • DB Support: DB2 LUW Add support for index DDL with INCLUDE columns and ALLOW REVERSE SCANS
  • DDL Generator Include precision and scale for NUMERIC types for Generic databases
    See the discussion here
  • Explain Plan Should be possible to specify a target schema for the explain plan tables in DB2 LUW
    See the discussion here
  • OS Support: Mac OS X Add support for high resolution Retina displays

Bugs Fixed

  • DB Support: DB2 LUW Multiple columns in the "Columns" tab for a DB2 table are labelled "NAME" instead of "TABLE_NAME" and "COLUMN_NAME"
  • DB2 LUW 9.7.6 with the 4.13 and 4.14 versions of the IBM JDBC driver gives erroneous top level objects in the Databases list which results in empty object details for other object types
    See the discussion here
  • Export @set maxrows have no effect when used in a @export on command
    See the discussion here
  • General A broken Java installation may result in an error while loading DbVisualizer (in sun.util.calendar.ZoneInfoFile.getZoneIDs)
    See the discussion here
  • OS Support: Mac OS X If DbVisualizer closed while the main window is maximized, it is impossible in following sessions to have DbVisualizer start-up in non maximized mode
  • References Exception may occur while the references graph is rendered with Java 7
  • SQL Commander The JDBC Connection#prepareStatement() is called with CRLF linefeeds when parsing for parameter markers
  • SQL Editor Incorrect caret position after selecting by double-clicking on second to last line
    See the discussion here

Improvements

  • DB Support: PostgreSQL Sequences should be sorted by name
    See the discussion here
  • General Updated bundled JDBC drivers to latest versions for DB2, PostgreSQL, SQLite, H2, MySQL and JavaDB/Derby
  • OS Support: Mac OS X Digitally sign DbVisualizer with Apple for the new Gatekeeper feature introduced in Mac OS X Mountain Lion
  • OS Support: Windows Digitally sign DbVisualizer on Windows to guarantee that the software is produced by DbVis Software AB and to prevent unnecessary warnings at installation

Bugs Fixed

  • Auto Completion Column completion does not work if a quoted table name is used as a qualifier
    See the discussion here
  • DB Support: DB2 LUW If Explain Plan tables already exist and there is a case mismatch between login user name and the explain plan tables schema an error is reported
  • The size for columns of type GRAPHIC and DBCLOB is not included in the DDL
  • DB Support: DB2 z/OS Displaying the source for VIEWS don't work with DB2 z/OS v10
  • DB Support: Oracle The DDL for VARCHAR2 columns lack the size information
    See the discussion here
  • DB Support: PostgreSQL Default schema is not determined correctly if search_path contain "$user"
  • DDL Generator Invalid syntax for column default values containing function calls, e.g. to_char(sysdate, 'HH24:MI:SS')
  • Export NPE when including indexes in Table Export with Generic Database Type
    See the discussion here
  • Grid Component The Aggregation Data for Selection is not updated when extending selection with cells on the same row
    See the discussion here
  • If moving a grid column and then show column header tooltip, information about another column is displayed
  • Key Bindings Cut, copy and paste key bindings in text fields on Mac OS X should follow the currently used key map rather than always require the CMD key
  • Navigator Deleting a table in the navigator pane may result in an exception
  • Query Builder IN and NOT IN operators with a single value cause an exception
  • Scripts The height of the lower details pane in the Script tab is reset between DbVisualizer sessions
  • SQL Commander Using the ~ operator in a SELECT statement results in a read-only result set
    See the discussion here
  • SQL Editor An exception is logged when typing some chinese characters
  • The syntax coloring is not properly updated after Comment Block and requires a scroll to fix
    See the discussion here

Improvements

  • General Add dbvisgui -windowtitle parameter for customization of the DbVisualizer window title

Improvements

  • Chart Make it possible saving default chart settings between sessions
    See the discussion here
  • General Increase default max Java memory for DbVisualizer from 256MB to 512MB

Bugs Fixed

  • Database Objects Tree Show Table Row Count does not work for tables with mixed case names or names containing reserved characters
  • DB Support: DB2 LUW Source for Procedures, Functions etc. not available when created with CREATE AND REPLACE
  • DB Support: SQLite Need to always treat non-decimal numbers as BIGINT and decimal numbers as DOUBLE to handle large values
  • Export Schema is not available for SQLite
  • Tables are not listed in alphabetic order under the Tables node
  • Export Empty CLOB/BLOB values are represented as NULL when exporting as Value
  • General Using a single right parenthesis as the variable prefix leads to invalid generated SQL
  • Import When importing very large files (more than 2,147,483,647 bytes), the progress indication is incorrect
  • Navigator No warning about pending edits when reloading the graph or deleting a selected node
  • Reloading the graph eats memory
  • Procedure Editor Ctrl+Enter in the procedure editor results in exception
  • SQL Commander Load and execute of a bookmark or monitor script don't load its visual layout between sessions
  • Stopping a query in the SQL Commander for Sybase IQ erroneously clears any partially retrieved result set
    See the discussion here
  • NullPointerException when using Execute Current with the caret in a comment on the first line
    See the discussion here

Improvements

  • Database Profile: Commands Add new continueonerror="true" attribute for the <Command> element
    See the discussion here
  • DB Support: DB2 LUW Missing "Schema Index" field in the Create Index action
  • DB Support: MySQL Include DEFINER attribute in CREATE PROCEDURE/FUNCTION/TRIGGER statement for Procedure Editor
    See the discussion here
  • DB Support: PostgreSQL Add Cascade option for the Drop Schema action
  • SQL Editor Use keybindings for Find Next/Previous also for Quick Find
  • Make the line highlight color configurable

Bugs Fixed

  • Chart An error occur when displaying a chart when all values in a serie is 0
    See the discussion here
  • Connection Setup Right-click on category labels in the Connection tab gives ClassCastException
    See the discussion here
  • Database Objects Tree Java 1.7: Reconnecting database connections may show an error
  • DB Support: PostgreSQL Support for the UUID data type is missing in the Create Table action
  • DB Support: Sybase ASE Show Default Database/Schema doesn't work with Sybase
    See the discussion here
  • Auto completion doesn't work for Sybase
    See the discussion here
  • Driver Manager Cannot load directory of driver classes in the Driver Manager
    See the discussion here
  • Import Colors indicating skipped rows in the import preview are not visible
  • SQL Commander Clicking in the Log to select the corresponding statement in the editor selects the wrong statement when it has been executed with Execute Current or Execute Selected
    See the discussion here
  • Pinned result set produced by procedures are not properly cleared at next execute or remove
    See the discussion here
  • SQL Editor An empty debug window is displayed (if auto popup is enabled) when pasting text copied from IntelliJ IDEA
  • Horizontal scrollbar disappears when moving the caret to the beginning of a single long line
    See the discussion here
  • Caret position is moved horizontally after a find and then press down keyboard button
  • Drag-n-drop database objects from another instance of DbVisualizer into the SQL editor results in an error
    See the discussion here

Improvements

  • DB Support: DB2 iSeries Support multiple result sets generated by stored procedure for DB2 iSeries
  • SQL Commander Should be possible to force presentation of the real column name even if column alias is used in queries
  • SQL Editor Make it possible to have Find scroll match to center of editor rather than just enough to show the match
    See the discussion here
  • Make it possible to turn off the caret blinking

Bugs Fixed

  • DB Support: Informix Default value is missing in the DDL for NOT NULL character type columns
  • DB Support: SQL Server An NVARCHAR(MAX) column is generated as NVARCHAR(0) in DDL
  • No code is shown for procedures, functions and triggers if the database name contains a space or other special character
  • DB Support: SQLite Column nullability and default value should be disabled in Alter Table
  • DDL Generator The primary key column order may be incorrect when using the Generic, H2, SQLite, Oracle or Mimer database types
    See the discussion here
  • Export Excel OOXML export may output special characters in wrong encoding
  • Navigator Related Table is not enabled when using Show in Navigator in the Data tab even when cells are selected
  • OS Support: Mac OS X Add workaround for the memory leak introduced in Java 1.6.0_29 on Mac OS X
  • SQL Commander Opening a non-existing file with File->Open Recent show truncated error and the file is then kept in the recent files list
    See the discussion here
  • SQL Editor Find All does not scroll to make the first match visible
    See the discussion here
  • Find Next does not use criteria set up by Find All
    See the discussion here
  • When pasting really fast after typing, Undo undoes both the typing and the pasting
  • Find does not reset highlighted matches made by Find All
    See the discussion here
  • Problem with special characters in the search string for Quick File Load
  • Table Data Editor Mime type for ZIP archives is wrong
  • Unrecognized binary data is marked as modified just by opening it in the cell editing window
  • Using column alias in selects may disable data editing for some databases
    See the discussion here

Improvements

  • DB Support: H2 Add support for linked tables in H2
  • DB Support: SQL Server Add enable/disable actions for triggers
  • Disabled triggers for SQL Server should be indicated with different icon in objects list
    See the discussion here
  • SQL Commander Column aliases in SELECT column list for MySQL 5.1+ don't appear in result grid
  • SQL Editor Text on the system clipboard is not included in the Paste Dialog
    See the discussion here

Bugs Fixed

  • DB Support: SQL Server Exception when switching to "Columns" tab with the SQL Server JDBC driver
  • SQL Commander Filtering log entries with "Show SQL" enabled will always display the SQL even if the entry doesn't match the enabled result categories (success/warning/error)
  • Very slow to convert a large result set to text
  • SQL Editor Unindent (Delete Tab) doesn't work for an unselected line with the caret at the beginning of the line
    See the discussion here
  • Comments are not highlighted if starting immediately after a statement delimiter

Improvements

  • Scripts Add "Open Enclosing Directory" command for script, history and favorite files
  • SQL Commander Redefine "Execute Current" to mean "Execute statement containing the caret or ending on line with caret"
    See the discussion here
  • SQL History Show file encoding in the SQL History feature

Bugs Fixed

  • Auto Completion Auto-completed names may contain whitespace
  • Command Line Support (dbviscmd) Variables used in the export file name retain the delimiters after substitution when executed via the command line interface
  • Connection Setup Changing some options, e.g. Authentication Method, does not add/remove related fields immediately
  • DB Support: HP Neoview If data format for numbers or decimal numbers in Tool Properties include thousand separator it may result in errors while walking the objects tree
  • DB Support: MySQL The SQL used internally to get a list if users does not work when sql_mode is set to ANSI_QUOTES
  • DB Support: PostgreSQL Exception when expanding Triggers node or opening Trigger Editor with PostgreSQL 9.1
  • Export Export to XLSX doesn't drop column headings when column data is dropped
    See the discussion here
  • Grid Component Quick filter doesn't work in the Variable Replacor window
  • Import Import doesn't properly handle embedded escaped quotes in quoted data i.e. 'smith''s'
  • Navigator Switching tabs with pending grid edits cause a NullPointerException
  • SQL Commander History file entries created by the SQL Commander are not using the encoding as specified in Tool Properties->Encoding
  • Clicking on the Locate Error Statement icon in the log when the script has been executed with Execute Buffer results in an exception
  • Disabling "Process Variables in SQL" or "Process Parameter Markers in SQL" have not effect and variables and markers are always processed
  • SQL Editor Caret position is misleading for CRLF line break, counted as two positions

Improvements

Bugs Fixed

  • Data tab Memory leak while reload in a SQL Commander result set or in the table Data tab
  • DB Support: Mimer SQL User Defined types are not expressed properly in the CREATE TABLE DDL
  • Grid Component Exception is raised if opening the cell editor with a (null) value
    See the discussion here
  • Query Builder Expressions containing operations (e.g. "a - b + c") are corrupted when loaded into the Query Builder
  • SQL Commander Showing result sets in the SQL Commander will generate an OutOfMemoryError with Alloy L&F and having the "Automatically Show Grid Warnings" enabled
  • SQL Editor Delete to Word Start/End only works once if the caret is in the middle of a word
    See the discussion here
  • The Insertion Point to End of Line shortcut moves the caret to a position one column beyond the end of line for scripts with CRLF (Windows) line terminators

Improvements

  • DB Support: Mimer SQL Show error position in the SQL log when running a statement in SQL Commander
  • Explain Plan The node tooltip should be disabled while in the magnifying mode
  • Grid Component Allow using the SPACE key to select entries in editable cell lists
    See the discussion here
  • Enable the hex viewer for any data type and not only binary/BLOB
  • The read-only only cell viewer window should include the button to convert XML (and any other formatted views) to plain text
  • Key Bindings Command-W should close tab/internal windows rather than Commands-F4 when using OS X key map
  • Table Data Editor Column names specified in different case may result in table data editing being disabled

Bugs Fixed

  • Auto Completion If a TAB precedes the completion list, the selection replaces all content on the line
  • Database Profile: Actions Actions with password data appear in clear text in the preview area
    See the discussion here
  • DB Support: DB2 LUW Explain plan don't work properly if setting the currentSchema driver property
  • VARGRAPHIC size is not included in DDL
    See the discussion here
  • Grid Component Java VM error may occur when using copy in grid or export
    See the discussion here
  • Scrollbars are not reset when loading a smaller CLOB in the Data Cell Editor
    See the discussion here
  • Navigator Selecting a Related Table with the mouse picks the currently selected entry and not the entry under the mouse
    See the discussion here
  • SQL Commander When passing a variable to the @run command, a "file does not exist" message is erroneously logged
  • SQL Editor Expand All does not adjust the horizontal scroll bar size appropriately
  • With Expand Tab to Whitespace enabled, the TAB key always inserts a fixed number of spaces instead of aligning at tab positions
  • The Comment Line/Block features comment only the visible region in the editor
  • The Comment Line feature comments the row where the caret is even if that row is not part of the selection
  • Caret is invisible or is not blinking while executing a script
    See the discussion here
  • The radio button in the Target section in the Find/Replace dialog can not be set by clicking on the labels
    See the discussion here
  • SQL History Details pane may not show in the Scripts and History features
  • Workspace Double-click a .sql file in the finder, DbVisualizer starts but the file is not loaded. (Works fine on Windows)

Improvements

  • Navigator Handle large list of Related Tables in a better way, e.g. make the list scrollable
    See the discussion here
  • SQL Editor Restore the 7.1 behavior for Insertion Point to End of Line
    See the discussion here
  • Add option to show non-printable characters (tab, whitespace, etc) in the editor
    See the discussion here
  • 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
    See the discussion here

Bugs Fixed

  • 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
    See the discussion here
  • DB Support: PostgreSQL Select composite type column gives exception
  • Exception or incomplete info when getting column info for DDL
  • DB Support: SQL Server The default schema cannot be determined for some database configurations
    See the discussion here
  • References Not possible to open references graph GML files in yED
  • A NullPointerException occur when exporting references graph in SVG or PDF formats
  • SQL Editor Selection not cleared by Move Caret o Next/Previous Word
    See the discussion here
  • Triple-clicking a line to select it and then extending the selection by dragging the mouse down deselects the first line
  • Delete Line clears all text but does not remove the line break
    See the discussion here
  • The action for moving/selecting to the previous word places the caret at the end of the target word instead of at the beginning
    See the discussion here
  • The statement parsing is off if a file containing CR linefeeds is loaded in to the editor
    See the discussion here
  • "Invalid location" warning when deleting all text as the first edit action
  • The caret placement may be off when the font specified in the settings file does not exist on the current platform
    See the discussion here
  • Copy of multiple lines and pasting them over the selection may lose indentation
    See the discussion here
  • Horizontal scroll with wheel/trackpad scrolls vertically
    See the discussion here
  • Extending the selection by dragging the mouse up in the row number area stops suddenly
  • 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
    See the discussion here
  • Table Data Editor After saving in data editor, edited cells may still show old value
    See the discussion here
  • While saving in the data editor, edited cells flicker and show the old value
    See the discussion here
  • Fix so that when editing a cell value (for duplicated rows) to the same value it currently have, should preserve the edited state
    See the discussion here

Improvements

  • Connection Setup Embedded databases taking filename as part of the database URL should offer a file chooser in the connection setup (Server Info only)
    See the discussion here

Bugs Fixed

  • Data tab The "Max Rows at First Display" setting have effect only for the very first table data being displayed
    See the discussion here
  • DB Support: PostgreSQL Exception or incomplete info when getting column info for DDL
  • Export Export in XLS/XLSX format occasionally leave the exported file locked by DbVisualizer
  • General Browsing the online documentation from the Help->Users Guide in DbVisualizer results in a 404 (Page not found) error
  • Import Changing Decimal Number Format in Tool Properties from Unformatted may lead to data truncation during import
  • Performance/Stability Occasional exceptions may appear at startup
  • SQL Commander Running SQL blocks may result in error
    See the discussion here
  • SQL Editor Changing SQL Editor font is not preserved for the primary editor when re-starting DbVisualizer
    See the discussion here
  • When dropping a name into the SQL editor the position of the cursor is not moved after the name but stay at the drop position
  • SQL Formatter The Format SQL->Paste Formatted clear the editor and reset undo buffer while it should just paste at caret position and keep undo buffer
  • Format SQL->Copy Formatted should operate on selection rather than whole buffer
    See the discussion here

New Features

  • Chart Replace the outdated charting component with a modern one (see related improvements below)
  • Connection Setup Add support for SSH tunneling
    See the discussion here
  • Redesign the Connect tab to enable SSH tunneling, more prominent placement of common properties, etc.
  • DB Support: H2 Add extended support for the H2 database
  • DB Support: JavaDB/Derby Add Sequence support for JavaDB/Derby
  • DB Support: Mimer SQL Add Explain Plan support for Mimer SQL
  • DB Support: SQLite Add extended support for the SQLite database
  • DDL Generator Add DDL generator and application support for CREATE INDEX
  • Export Add Export actions for individual object, i.e. View, Procedure, Function, Package, Package Body, and Trigger
    See the discussion here
  • Add support for export in OOXML (xlsx) format. Enables export of more than 65K rows in a single sheet
  • Add TXT export format used to export fixed width columns output (grid export only)
  • General Add support for the -connection, -userid and -password arguments for the DbVisualizer GUI. When passed as arguments then automatically connect the database connection at startup
  • Adapt DbVisualizer for the upcoming Java 1.7 version
  • Grid Component Add "Copy Selection as Text (With Column Header)" in the grid right-click menu
  • Navigator Allow editing in the Navigator grid
    See the discussion here
  • Add Quick Filter for the Navigator grid
    See the discussion here
  • SQL Commander Add "Show Object at Cursor" feature that will locate the object at the cursor position and show its details in window
    See the discussion here
  • SQL Editor Replace the SQL/text editor component to allow for various improvements (see below)
  • Workspace Optimize screen estate usage. Allow for configuring visibility of certain components

Improvements

  • Auto Completion Auto completion doesn't work if command is "WITH"
  • Add the supported client side commands to the auto completion popup
  • Auto Completion should show database specific reserved words
  • Chart Support date/time/timestamp columns in X axis with proper scaling
    See the discussion here
  • A monitor script with manually adjusted chart settings are not used if re-executing the monitor in the SQL Commander
    See the discussion here
  • Chart setting changes made in the SQL Commander should be used automatically for new charts
    See the discussion here
  • Make more chart settings persistent
  • Automatically setup serie in chart at first display
  • Support GIF export format for Charts
  • A bookmark in SQL Commander should apply any chart settings from the bookmark
  • Command Line Support (dbviscmd) Use a better error message when the specified connection does not exist
    See the discussion here
  • Connection Setup Using the connection wizard to create a connection should insert the new connection based on the current object tree selection
  • Change the controls to make it clear that Save Password and Clear Password at Disconnect are mutually exclusive
    See the discussion here
  • Create/Alter Table Include table name in constraint name suggestions
  • Data tab The data filtering feature automatically add WHERE first making it impossible to manually add for example "with (NOLOCK)". Fix by allowing !WHERE to be specified first in the filter
  • Database Objects Tree The cache with primary keys and unique indexes need to be reset when reloading the objects tree (and also implicitly at reconnect)
  • Database Profile: Actions The object action window need to be bigger for some actions such as "Create Tablespace" in Oracle
  • Unsaved edits in the object action window should be confirmed when user request canceling the action
  • DB Support: Oracle The list of TNS names for Oracle should be sorted
    See the discussion here
  • Use the temporary table SYS.PLAN_TABLE$ for explain plan in Oracle 9+
    See the discussion here
  • Better support for "Object Type" objects in Oracle
  • Add "resize datafile" and "add datafile" actions for UNDO and TEMP tablespaces
  • ASM updates for Oracle
  • Support for Oracle rules, /*+rule */, without need for special configuration
    See the discussion here
  • DB Support: PostgreSQL Support for array types in DDL
    See the discussion here
  • DB Support: SQL Server Show computed column expression in DDL
    See the discussion here
  • DB Support: Sybase ASE Order objects based on schema and name, as opposed to just name without regard for the schema
  • Explain Plan Add copy to clipboard functionality for explain plan result set
  • The tree view in explain plan should be exportable
  • Copy Selection as Text and Export Grid (TXT and HTML formats) in Explain Plan grid should indent the tree column accordingly
  • Export Make it possible to select how to delimit SQL blocks for procedure DDL
    See the discussion here
  • Option to control position of SQL statement in export output (above/below result set)
  • Favorites Add Replace action for a favorite that references a database object. This should replace the information for the favorite with the data for the selected database object
  • General Quitting DbVisualizer should wait for all active connections to properly disconnect
  • Menubar items are not anti aliased when running DbVisualizer in Linux
    See the discussion here
  • Import Optionally drop an existing table with the same name when using Import to New Table
    See the discussion here
  • Add copy/paste support in "New Database Table" and in the "Map Table Columns with File Columns" import table data grids
  • Installation Allow command line flag to the installer that disable file associations when installing in silent mode
    See the discussion here
  • Monitor Should be possible to hide the toolbar for each monitor window/tab
  • Save chart font, colors and other settings with monitor
  • Auto started monitors need to run the connect prompter
  • Navigator Add possibility to select a row in the Data tab grid and use it as start for the Data Navigator
    See the discussion here
  • OS Support: Mac OS X Mac OS X: Option to add newly installed version in the Dock
  • Print Print text in the SQL Editor as text instead of as a screenshot
  • Query Builder Improve the support for CASE clauses in a query
  • References Add option to control whether compound references should be rendered only with one link
  • Add an option to control auto zooming when searching in the references graph
    See the discussion here
  • Scripts Loading a file from the Scripts tab should use the Default File Encoding in Tool Properties if encoding for the file is not set
  • Minimize file access operations to increase performance when accessing files on remote hard drives
    See the discussion here
  • SQL Commander Should be possible to open a .sql file and load it into a running instance of DbVisualizer
  • Connections with same alias aren't visibly differentiated in for example the Connection drop down in the SQL Editor
  • Path errors in the @run and @cd command should be handled just like other errors instead of showing an alert dialog and stopping the execution
  • Allow for relative paths to be used with the @cd command
  • Caret position and focus in SQL editors should be preserved when jumping between editor tabs using mouse
    See the discussion here
  • Add support for ${dbvis-pwd} that will be replaced with the current directory
    See the discussion here
  • Add new setting to control whether result sets produced in the SQL Commander always should be read-only
  • SQL Editor Allow change of background color in the SQL editor and foreground color for text
    See the discussion here
  • Support for code folding in the SQL editor
    See the discussion here
  • Must be possible to change colors in the editor
  • Color-coding should not interpret backslash as an escape character other than for MySQL databases
    See the discussion here
  • Underline should not be considered a separator between two words on double click i.e. both words and the underline should be selected
  • When opening a new SQL Editor the settings for Max Rows/Max Chars should pick their values from the previously displayed editor
    See the discussion here
  • Should be possible to disable bold for keywords in the SQL Editor
  • Add database specific highlighting of reserved words
  • Insertion "Point to Next/Previous Word" should ignore underscore characters
  • Add a "Search Scope" in the SQL Editor Find feature
    See the discussion here
  • Support regular expression in Find
  • SQL Editor shall have focus when going to SQL Commander directly after start-up of DbVisualizer
  • SQL editor should support anti-aliased fonts
    See the discussion here
  • Make it possible to change the selection color
    See the discussion here
  • Show position of caret based on current statement
  • Add support for editing macro recording and playback
  • Add support for Paste from previous clipboard content
  • SQL History Quick filter in the SQL History should support searching the SQL script content
    See the discussion here
  • Table Data Editor Table data editor should keep focus when saving or reloading the data
  • Save and undo buttons in table data editor are not activated when editing a single cell or when using functions to fill a single cell
    See the discussion here
  • Add Enable/Disable All buttons in the key column chooser
    See the discussion here
  • Table Data editing should not rely on the variable identifier/delimiter specified in Tool Properties
  • Tool Properties The settings for proxy should automatically be picked from the system
  • Workspace Support drag and drop of bookmark, monitor and favorite files between DbVisualizer and external tools such as Windows Explorer, Finder (Mac) and File Browser (Linux)
    See the discussion here
  • Adjust all windows so that they are no bigger than 1280x800

Bugs Fixed

  • Auto Completion Manually specified qualifier is removed when using auto completion
    See the discussion here
  • Auto completion doesn't show if name is immediately preceded with a slash
    See the discussion here
  • Table hint for SQL Server is treated as alias in the auto completion feature
  • Auto completion should use the database/catalog qualifier when looking for matching tables and columns
    See the discussion here
  • Database Profile: Actions The SQL Formatter spins forever when formatting the action SQL for Create Synonym
    See the discussion here
  • DB Support: Oracle Cannot use a plan_table referenced with a public synonym
  • General Copy text from IntelliJ IDEA results in a low level warning message being printed in the debug window
    See the discussion here
  • Performance/Stability Memory leak while running a lot of actions
    See the discussion here
  • Memory leak
  • SQL Editor Color highlighting for comments in the SQL editor doesn't match the settings of comment identifiers
  • Syntax coloring doesn't render properly if certain character combinations are in the editor buffer
  • Netbeans editor suddenly disappear on Windows
  • The warning "The file has been modified externally after it was originally loaded" in the SQL editor may appear erroneously if the file is stored on a network drive
    See the discussion here
  • Extend Selection to Beginning of Line (or Beginning of Text on Line) should not restart selection
    See the discussion here
  • SQL Formatter Formatter breaks erroneously on "TIMESTAMP<BR>WITH<BR>TIME ZONE..."
  • Table Data Editor If selecting a cell directly start edit the value no cursor appear

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