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 9.2

Select version

Release Notes

Bugs Fixed

  • Connection Setup Sporadic error may occur during connect

Improvements

  • Driver Manager The connect error when using the deprecated JDBC-ODBC driver in Java 8 need to be more informative
  • SQL Commander Make it possible to filter Database and Schema list values

Bugs Fixed

  • Connection Setup NPE when connecting and using master password
  • Create/Alter Table The Referenced Table lists in the Foreign Keys tab do not reflect the selected Database
  • Exception if Size field contains a blank
  • DB Support: Informix Show the type of trigger in the Triggers tab for a table
  • DB Support: Other NPE when using QB with IProtect (Aurora) database
  • DB Support: SQLite "[SQLITE_ERROR] SQL error or missing database (near ")": syntax error)" is reported in the indexes tab for a table that have no indexes
  • Indexes tab gives exception for DEFERRABLE declared index
  • DB Support: Vertica Remove the DDL tab for System Table nodes
  • Export Qualifier specified in Export action dialogs is not used in DDL statements
  • The rowCount parameter should not be generated since it is replaced with @set maxRows
    See the discussion here
  • General Tooltips are displayed sporadically
  • SQL Commander Exception when an @export block contains an @echo command
  • Parameter marker fails for similarly named parameters

Bugs Fixed

  • Connection Setup Drivers with java.sql.DatabaseMetaData.getSchemas()/getCatalogs() methods returning a null ResultSet fail to connect
  • DB Support: DB2 LUW View for the DBA Views/Locks does not work
  • DB Support: Informix Enabling "Show Only Default Database/Schema" filter doesn't do anything for Informix
  • DB Support: MySQL TIME, DATETIME and TIMESTAMP data types lacks fractions in DDL
    See the discussion here
  • DB Support: NuoDB Create view does not prepend schema name
  • Drop trigger (table-trigger) does not work for nuo DB
  • DB Support: Oracle NPE when canceling the Alter Table dialog
  • DB Support: SQL Server DATE suggested as data type for String column at Import
  • DB Support: SQLite Script View action may give a table not found error
  • DB Support: Vertica, Import Import suggests non existing type when import decimal number
  • Export No end tag when exporting result grid as XmlDataSet or FlatXmlDataSet
  • Excel crashes when + icon is clicked for an exported binary xls document
    See the discussion here
  • The rowCount parameter should not be generated since it is replaced with @set maxRows
    See the discussion here

Improvements

  • DB Support: Mimer SQL Update the Mimer JDBC driver to 3.35b(19427)
  • DB Support: MySQL Do not quote an already quoted default value for a column
  • DB Support: Oracle RAW data should be displayed as a Hex String by default
  • Add connection property to hide the DBMS Output tab in the SQL Commander
    See the discussion here
  • DB Support: SQLite The default database file name for SQLite should not include the tilde (~) character
  • DB Support: SQL Server Upgrade the bundled jTDS driver to 1.3.1
  • DB Support: Sybase ASE Upgrade the bundled jTDS driver to 1.3.1
  • Export Changed settings in the last Export Grid pane are not saved when Settings->Save as Default Settings
  • OS Support: Mac OS X Should be possible to show the Monitor window in OS X fullscreen mode
  • References Add option to render only selected tables in the References graph
    See the discussion here
  • Mark foreign key with icon in reference graph
  • SQL Commander Add tool property to control focused result set tab after execution (Result Sets->Focused Result Tab after Execution)
    See the discussion here

Bugs Fixed

  • Chart The Auto Adjust Start Value/Manual Start Value settings are also applied to the corresponding "End" settings when chart configuration is saved to file
    See the discussion here
  • Connection Setup The specified method name for any of java.sql.statement.X and java.sql.connection.X driver properties need to be trimmed
  • Data tab Current sorting and cell selections are not cleared when opening another table in the same Data tab
  • Driver Manager Driver Name and Version String are not reset when loading new JAR file
  • Filtering/Filter Sets The Data tab filter editor window errors if defining an IN or NOT IN value with multiple subsequent commas
  • Grid Component Grid column chooser configurations are not saved between reloads or DbVisualizer sessions
    See the discussion here
  • Monitor ConcurrentModificationException when running monitors
  • Navigator Regression in 9.2.13 preventing Data Navigator from working properly
  • SQL Commander @-command parameters with unquoted values should not be silently ignored
  • Exception while SQLEditor discovers that the Database Connection drop-down changed
  • Table Data Editor Inserting new rows or duplicate existing in the table data editor aren't sorted based on current column sorting
  • Undoing edits in a sorted table data editor doesn't resort the grid if sorted

Improvements

  • Chart Should be possible to set Y-axis end value in chart properties
  • Connection Setup SSH should not be available for connections accessing for example the file system
  • DB Support: Other Add driver entry for Snowflake
  • DB Support: SQL Server Add a DDL tab for Index nodes
  • Database Profile: Commands Add support for DatabaseMetaData.getSchemas(catalog, schema) in database profiles (getSchemas2)
  • SQL Editor Make the mouse click modifier for rectangular selection configurable
    See the discussion here

Bugs Fixed

  • Chart Chart is not properly scaled if having decimal numbers as series with very small differences (<0.01) between min and max
  • Colors for series may change if selecting/de-selecting more/fewer series
  • Chart zooming is reset when modifying chart properties, change series/category, and when chart being reloaded
  • Connection Setup Ping button may become disabled/enabled in situations when it shouldn't
  • Connection cannot be established if getting login schema/database fails
    See the discussion here
  • DB Support: JavaDB/Derby DDL tab for trigger is empty for Derby database
  • DB Support: MongoDB DataDirect driver for MongoDB returns a null column name for columns generated by a function
  • Data tab Column selections made in the Data tab column chooser are not propagated when "Copy complete SQL" and in the grid right-click "Script to SQL Commander" commands
    See the discussion here
  • Save in the Data tab doesn't keep any (inline) data filter when grid is reloaded after save
  • Generate Sorting Filter for Column Sorting in Data tab right-click Generate Filter & Sort menu only works if Include Grid Sorting is checked
  • Using a filter in the Data tab that results in "An error occured..." results in that column names can no longer be auto completed
    See the discussion here
  • Grid Component Copy cell(s) in grid inserts a new line at the end of the copied data
    See the discussion here
  • Hide Column no longer works using the mouse
  • Hiding column(s) in the SQL History cannot be restored without re-starting DbVisualizer
  • Import Data skipped in XLS import
  • Precision of decimal numbers during import and table data editing may be affected by the Decimal Number Format tool property
  • Monitor A monitor without a connection specified should not be started
  • Potential synchronization issue when executing multiple monitors for different schemas/databases using the same database connection
  • OS Support: Linux "sun.awt.image.BufImgSurfaceData cannot be cast to sun.java2d.xr.XRSurfaceData" exception should not be reported as a warning in the error log
    See the discussion here
  • OS Support: Mac OS X Java 8: If dragging a database object to the SQL editor the Script dialog freeze and don't accept any input except the ESC button
  • Object View ClassCastException when Restore Hidden Tabs on a nested DataView
  • SQL Commander Permission checker should ignore statements being comments
  • A comment in the script before executing a SELECT statement will disable result set editing unless Strip Comments when Executing is checked
    See the discussion here
  • @run should result in an error when the specified path is not a file, e.g. when it is a folder

Bugs Fixed

  • DB Support: MySQL Occasional NullPointerException when generating DDL
  • DB Support: Oracle Exception when generating DDL for a View or when getting CLOB values
  • DB Support: Vertica The Referenced Table and Referenced Columns are not set for a foreign key in Alter Table dialog

Improvements

  • Connection Setup Upgrade JSch to version 0.1.53
  • Create/Alter Table Specifying a referenced column for an FK should be optional
  • DB Support: Mimer SQL Enhance Mimer explain to handle new "partial" mode whereas these nodes should be rendered in orange color
  • DB Support: PostgreSQL Add support for function parameter default value in the DDL generator
  • Grid Component Allow assigning key binding to Remove Column (grid column header right-click menu)

Bugs Fixed

  • Connection Setup Make the Ping Server dialog more informative that it is used to do a basic ping with the server and not a full Test Connection procedure
  • DB Support: Informix CLOB values may be corrupted when loaded if the database use non-default character set
  • DB Support: MySQL Add auto increment column fails for Alter table
  • Altering a column to primary key and auto increment does not work
  • DB Support: NuoDB NuoDB erroneously returns a backtick (`) as getSearchStringEscape() while it should return a backslash (\)
  • DB Support: PostgreSQL Parameter markers starting with :: followed by whitespace is erroneously prompted as a marker
  • DB Support: Sybase ASE Getting procedure's DDL from different schemas under the same connection fails when using the jTDS driver
  • Procedure Editor shows no source for Sybase ASE 16 or later
  • DB Support: Vertica Some tree nodes are not sorted, e.g. user names under the Users node
  • Data tab Reload in the Data tab doesn't apply any (inline) data filter changes unless Use Filter button has first been clicked
  • Database Objects Tree Occasional NPE when reload database objects list
  • Export XmlDataSet and FlatXmlDataSet should have just one <dataset> element embedding all tables, not one for each table
  • @export of two result sets in CSV to the same file will append the second result sets first line to the last line of the first result set
    See the discussion here
  • Import Importing number containing a blank as thousand separator does not work
  • Java 8 DbVisualizer fail to start with IBM Java 8
  • Procedure Editor The editor should be cleared when the source code cannot be retrieved
  • SQL Commander Make it possible run script with no internal SQL being executed
    See the discussion here
  • Having a permission level that shows the confirmation dialog in the SQL Commander in combination with OS X and Java 8 causes the variable dialog to not accept text entry

Improvements

  • DB Support: Hive Add a Database Type for HIVE enabling for example SSH support
  • Adjust the Data tab and result set tabs for HIVE to enable data editing
  • OS Support: Mac OS X Verify DbVisualizer with Mac OS X 10.11 (El Capitan)
  • References Add support for mouse wheel to scroll in graphs. (Use Alt+MouseWheel or Ctrl+MouseWheel to zoom)
    See the discussion here

Bugs Fixed

  • Auto Completion Sporadic exception while using auto completion in SQL editor
  • DB Support: DB2 LUW Catch AIOOB if extracting DDL fails
  • DB Support: Hive The error log complains about setAutoCommit() warnings for HIVE
  • Database Profile: Actions In the error dialog that is displayed after unsuccessful execute of an action, double-click the rightmost cell value and a CCE is displayed
  • Grid Component Occasional ArrayIndexOutOfBoundsException when reloading a result set
  • The XML viewer should check the target database data type in addition to the content mime type to determine if it's XML or not
  • Hiding a column in a grid on Linux with DbVisualizer running on a secondary monitor fail with some Linux distros/environment setups
  • Import The import progress information is not updated when importing from Excel
  • CSV import does not detect carriage return (\r) as representing new lines
  • If errors occur while import Excel (xlsx) the error row number reference is wrong
  • Import does not honor "Import Only" properly as error rows are not counted
  • The Import progress information is only updated every 100th inserted row rather than at least once per second
  • References java.awt.geom.IllegalPathStateException: missing initial moveto in path definition in references graph
  • The references List view should translate the values for UPDATE_RULE, DELETE_RULE and, DEFERRABILITY to readable text
    See the discussion here
  • While References graph is loaded a small blue box is rendered on top of the nodes
  • SQL Commander Inconsistent display of rollback/commit dialog when auto commit off
    See the discussion here
  • The Auto Commit status bar item is always Auto Commit: ON for disconnected connections and before the very first statement has been executed
  • SQL Editor Find next/previous (fn+F3) in quick search shows any search previously made in the find with dialog
  • Rectangular editing does not change last line correctly when selecting top right to bottom left
    See the discussion here
  • Table Data Editor An editable grid with a large number of rows (ex 100,000) which is sorted takes unreasonable long time to reload, close (tab) or even quit DbVisualizer

Improvements

  • DB Support: Vertica Support hints /*+ .... */ comment syntax for Vertica
  • OS Support: Windows Verify DbVisualizer with Windows 10
  • SQL Commander Parameter marker :variable:indicator should be handled as one parameter and not two
  • Add "New SQL Commander" to "SQL Commander" tab menu
  • Show actual exec time for failed statements in the SQL log rather than 0.000

Bugs Fixed

  • Connection Setup Some connection properties fields are only editable in corresponding standalone window (text editor, file chooser)
  • StackOverflow when editing a value in Driver Properties
  • DB Support: Mimer SQL Parameter markers identified by JDBC driver is not discovered unless either named or unnamed markers are in the SQL being executed
  • DB Support: SQL Server Show Column nodes for a View in the tree
    See the discussion here
  • DDL Generator If an error occurs for a column while extracting DDL this is silently ignored and extractor continues thinking the data is good to parse
  • Database Objects Tree Renaming a folder in the Databases tab doesn't preserve if immediately selecting another node
    See the discussion here
  • OS Support: Windows Cannot open system clipboard
  • Table Data Editor Potential StackOverflowException in Key Column Chooser (Table Data Editor)

Improvements

  • DDL Generator Include DDL tab for tables in generic database profile (DbVisualizer Pro)
  • SQL Commander Allow execute current/execute selected statement in the SQL Commander in DbVisualizer Free
  • SQL Editor Make auto-indent configurable in Tool Properties

Bugs Fixed

  • Connection Setup Honoring searchStringEscape should be disabled for generic databases
    See the discussion here
  • Connections can be created with the same name
  • DB Support: Vertica Drop View action runs SQL drop table including cascade
  • Database Profile: Actions Regression in Script Table whereas time/date/timestamp values are propagated with current time instead of a empty quoted string
  • Export The ${dbvis-object}$ variable is not resolved in Filename when ExcelFileFormat is "ooxml"
  • Import Wrong sheet is used when a sheet is chosen for XML import (xlsx)
  • OS Support: Linux Error with IBM Java 7: java.lang.NoClassDefFoundError: com.sun.org.apache.xml.internal.serialize.OutputFormat
  • OS Support: Windows Settings files may be destroyed if performing an uncontrolled shutdown of Windows
  • SQL Commander Failing setting schema makes schema drop-down change
  • If an array or struct data type hold primitive types DbVisualizer reports an error
  • Auto Completion fails if the statement is preceded by a comment
  • SQL Editor Right-click outside a selected text area deselects the text on Windows
  • Replace All Backwards may freeze DbVisualizer
  • Template abbreviations are only expanded if preceded by whitespace
    See the discussion here
  • Setting database in Editor not possible if multiple database exists with same name
  • Tool Properties Import/export of user settings may fail with a java.lang.ArrayIndexOutOfBoundsException
  • Empty file named "unnamed" in keymaps dir after import settings

Improvements

  • Auto Completion Make it possible to initialize Database/Schema to Connection Default, None or Most Recent
    See the discussion here
  • Connection Setup Add a connection property used to disable honoring searchStringEscape in JDBC driver
  • DB Support: Oracle Add Grants tab for Materialized View

Bugs Fixed

  • App Logging Connecting to HSQLDB gives StackOverflowException since 9.2.4
  • Create/Alter Table If JDBC driver provide an empty list of supported data types an error occur in create/alter table and table data import
  • Exception may occur in Create/Alter Table and the columns tab while searching data types
  • DB Support: DB2 z/OS The Create and Drop options are missing for Script Table and Script View
  • Filtering/Filter Sets Values for "in" filters doesn't restore at restart
    See the discussion here
  • Query Builder Identifiers starting with numbers must be delimited (quoted) when loading into the Query Builder to avoid errors
  • DbVisualizer freezes when all joins are removed
  • SQL Commander Selecting the [Choose Connection] entry in the Database Connection drop-down gives an error
  • @ddl and @desc commands only support one qualifier
  • Having a variable in string format with more than 4 elements results in an exception
  • Selected Database/Schema should not be reset when connecting or disconnecting
  • Catalog/Schema drop-downs are not updated after execution to reflect any changes of catalog/schema in the script
  • Tool Properties Exception while loading border files that are not images

Improvements

  • DB Support: NuoDB Add support for user defined functions in NuoDB 2.2
  • Filtering/Filter Sets Add object filters for: like, not like, and regex
    See the discussion here

Bugs Fixed

  • App Logging dbvisgui.sh -help and -version outputs to the error.log rather than the console
  • DbVisualizer fails to start if initialization of logging fails
  • Compare No colors in margin until scrolling
  • Connection Setup The file browser for e.g. the Database field does not allow a folder to be selected
  • Switching between Connection Type: Service and SID for Oracle connections may result in an error
  • A connection previously used by a closed SQL Commander may be reused for a new SQL Commander
  • DB Support: Informix Catalog separator (:) for Informix does not work in 9.2
  • DB Support: SQL Server Cannot drop column with default value via Alter Table due to dependency on system object
  • General Escape any _ and % characters in arguments to JDBC meta data calls
  • Grid Component Selecting entry from data type drop-down in Create/Alter Table using mouse doesn't work on Linux
  • Import NumberFormatException in Import of XLSX
  • Reloading Table Details may cause an exception
  • Exception may occur when Load Default Settings in import wizard
  • Empty column included in wizard when importing excel
  • Import does no longer save certain wizard settings when saving defaults
  • Suggested size for number does not change when changing preview rows during excel import
  • References java.awt.geom.IllegalPathStateException: missing initial moveto in path definition in references graph
  • SQL Commander GO delimiters must be written in lowercase
    See the discussion here
  • An error occurs if a user specified log file is locked by another application and the execution is halted
  • Allow formatting of custom Date/Time/Timestamp variables in the same way as for predefined date/time variables
    See the discussion here
  • Having for example @echo before any SELECTs in a script results in that the Database drop-down selection is not used to set current database
  • SQL Editor A line comment just before a @delimiter command cause an error when triggering auto-complete

Improvements

  • Chart Change default number format for Y-axis labels to #,##0,#
    See the discussion here
  • General Allow log files to be attached to a Contact Support request

Bugs Fixed

  • DB Support: PostgreSQL Constraints with the same name in multiple tables are included in the DDL for all of those tables
  • Database Objects Tree Sporadic NPE when re-connect
  • General OverlappingFileLockException during startup
  • Java 8 Mac OS X and Java 8: A single ArrayIndexOutOfBoundsException occurs without any stack trace and after that the UI is unresponsive
  • SQL Commander "Database connection cannot be changed while executing" is displayed randomly
  • A line comment just before a @delimiter command cause an error when triggering auto-complete

Improvements

  • Command Line Support (dbviscmd) Make the command line honor the Strip Comments setting by default
    See the discussion here

Bugs Fixed

  • DB Support: Oracle :new.xxx and :old.xxx should not be prompted as parameter markers
  • Driver Manager Regression in the DriverManager resulting in JdbcOdbcDriver always being used in a custom driver
  • Import Import CSV doesn't work properly
    See the discussion here
  • SQL Commander Unexpected prompting for parameter marker values may occur if there is an empty quoted string earlier in the SQL
    See the discussion here

Improvements

  • Java 8 Experimental support for Java 8

Bugs Fixed

  • Command Line Support (dbviscmd) A statement with any kind of delimited text, such as a quoted string, is not executed
  • Navigator The Max Rows setting is not honored
  • Query Builder Aggregator functions are not recognized as such when loading SELECT statement
  • SQL Editor Print Preview and Print may cause error when lines must be wrapped to fit on page
  • Tool Properties Changing Presentation of CLOB Data to Value doesn't survive between sessions

Improvements

  • DB Support: MySQL Add support for explain plan in MySQL

Bugs Fixed

  • Chart Copy chart to clipboard don't work on Mac OS X
  • DB Support: Informix A colon in an identifier is processed as a parameter marker
  • Driver Manager Having P6Spy in a JDBC driver jar file will fail during search of drivers
  • Filtering/Filter Sets Object filters that are migrated from pre 9.2 versions re-appear when deleting them in 9.2.x
  • Object filtering drop-down entries are not selectable when they should
  • General The -DMaxPermSize Java property is not supported with Java 8
  • Grid Component Selecting all cells in a grid by clicking row number and then Command+C copies the row number rather than the selected data cells
    See the discussion here
  • Key Bindings Create a key binding gives an error with Java 8
  • Navigator Exception may occur while opening related tables in the Data Navigator
  • OS Support: Mac OS X Exception using key binding in SQL Commander with Java 8 on Mac OS X
  • Dropping tables in Query Builder results in an error with Java 8
  • Mac OS X fullscreen support is fixed in Java 1.8.0_20
  • Java 8: "Invalid parameter not satisfying: [self canBecomeMainWindow]..." may appear when actions are executed
  • Holding down a letter key in a text component can freeze the GUI
  • Procedure Editor No trigger source is shown if the BEGIN or DECLARE keyword is not the first word on a line
  • SQL Commander Backslash-escaped quotes in strings cause incorrect parsing of an SQL script
  • An SQL Block end delimiter on the last line without a corresponding start delimiter results in an ArrayIndexOutOfBoundsException
  • With "Strip Comments when Executing" disabled, statement delimiters (e.g. ";") in a comment results in the comment being sent in pieces to the database
    See the discussion here
  • SQL Editor Loading a SQL history entry in a modified editor should include a "Do not show this message again. Always Discard & Load" setting in the warning dialog
  • If holding a key in the SQL editor to repeatedly insert a character only a single char is inserted (as per OS X defs) but after that it is impossible to insert any character at all
  • Tool Properties Mac OS X: Cannot change font with mouse in Tool Properties - SOLVED by using Java 1.7.0_72 and later
  • Export/import user settings doesn't work as database connections are empty
    See the discussion here

Improvements

  • DB Support: DB2 iSeries Add setting for DB2 iSeries to convert CHAR FOR BIT data to text
  • DB Support: MySQL The MySQL driver should by default disable the "Buffer All Rows for a Result Set" to minimize memory issues
  • Export Custom sheet name for Excel export
    See the discussion here

Bugs Fixed

  • Connection Setup Updating a connection with an empty SSH Tunnel section may cause an error
  • DB Support: Vertica Show argument types next to name for SQL Functions and UDFs in the Databases tab
  • The Function Editor may load the wrong source for an overloaded SQL Function
  • Database Objects Tree Occasional errors may happen while browsing database objects or during schema export
  • General Unable to startup due to configuration file issue(s)
  • Grid Component A large number of dbvis-<n>.<x> files in the temporary directory
    See the discussion here
  • Import Exception in wizard when preparing import of excel file (xslx)
  • Key Bindings Remove Next/Previous Word default key bindings not correct on all platforms
    See the discussion here
  • OS Support: Mac OS X Unattended install (-q) shows a window
    See the discussion here
  • Procedure Editor Parameterized SQL must be enabled regardless of user setting for the SQL Commander
  • Query Builder Invalid keyword may result in an error when loading a SELECT statement
  • SQL Commander Error parsing parameter markers
  • SQL Editor Parameter markers incorrectly detected when between brackets or backtick quotes
  • Table Data Editor Result set is not editable if using a sub query in the select statement
  • Tool Properties An error may occur when import of user settings

Improvements

  • Auto Completion Full auto completion support for client side commands and their parameters
    See the discussion here
  • Compare Allow comparison of two cells in the same grid
    See the discussion here
  • Connection Setup Re-introduce the "single physical database connection" behavior
    See the discussion here
  • Add support for editing multiple database connections
    See the discussion here
  • Add optional master password protection for DbVisualizer
  • Add a Connection Keep Alive feature
    See the discussion here
  • The DB2 z/OS database type should be set when using the DB2 z/OS driver definition
  • DB Support: DB2 iSeries The Schema list in the SQL Commander should really change the current schema
  • DB Support: H2 Upgrade to H2 1.3.175
  • DB Support: Oracle Add DDL support for GLOBAL TEMPORARY TABLE
  • Add support for export of sequences and synonyms in Export Schema
  • DB Support: PostgreSQL Add support for editing HSTORE, JSON and JSONB values in the grid
    See the discussion here
  • DB Support: SQLite Upgrade to SQLite 3.8.6
    See the discussion here
  • Database Objects Tree Make it possible to hide certain object types
    See the discussion here
  • Support for multiple named filters
  • Support filter sets with pre-defined filters that can be switched easily
    See the discussion here
  • Support sharing object tree filters between database connections
  • Allow de-activating some filters in the objects tree
  • Ensure Database Connection and Folder names are unique under its parent node
  • Support more filtering conditions (ex in, not in, starts with, contains, ...)
  • Database Profile: Actions Allow showing result sets generated by action in a text viewer
    See the discussion here
  • Export Exported binary Excel files has sheets selected initially resulting in edits being made in one sheet are propagated to all sheets
    See the discussion here
  • Default sheet names does not follow Excel standard at export (Sheet1, Sheet2, Sheet3)
    See the discussion here
  • Should be possible to specify qualifiers and delimited identifiers (for SQL format) in Export
  • Grid Component Add option to allow free horizontal scrolling in grids instead of the current column-by-column based scrolling
  • Add new Copy Selection actions to grids: Copy as Comma list, Copy as IN clause
    See the discussion here
  • Import Add support for Excel (xls/xlsx) import of table data
    See the discussion here
  • Make it possible to specify in which row any header starts and the data in CSV import
    See the discussion here
  • File row numbers in import preview panel
    See the discussion here
  • Import into new table with a DECIMAL column should suggest size,scale for the DECIMAL data type
  • Installation/Update Installation Offer a Debian software package installer
  • Key Bindings Can't set key bindings for Tools->Compare
    See the discussion here
  • OS Support: Windows Show splash screen when starting second DbVisualizer instance
  • SQL Commander An SQL Commander tab with a file loaded should be removed at next startup if the referred file has been deleted and the SQL Commander is not modified & auto-saved in previous DbVisualizer session
  • Allow having the Log and all result set tabs in a floating window that persist as long as the SQL Commander tab or when docked
    See the discussion here
  • The Set Auto Commit command in the SQL menu should show on/off based on current mode to make it more intuitive
  • The Schema list in the SQL Editor should really change the current schema for PostgreSQL
  • Allow use of parameter markers (?, :pm, &pm, or :{pm}) for any database
    See the discussion here
  • Support the :'x' parameter marker format
  • Add a @sleep command
  • Add new client side command (@set resultset name <name>) used to set a name for the next result set
  • SQL Editor Add support for pre-defined templates and custom SQL templates
    See the discussion here
  • SQL Formatter Option to format a SQL statement into a single line by removing newlines, tabs, etc.
    See the discussion here
  • Table Data Editor Show current cell data format in the table editor status bar
  • Tool Properties Import Settings should merge database connections

Bugs Fixed

  • DB Support: SQLite [SQLITE_NOTADB] File opened that is not a database file (file is encrypted or is not a database)
  • DB Support: Vertica "Map to String" viewer for Flex Tables show an error
  • Export Export to XLSX doesn't output non-printable characters properly
  • Installation/Update Installation Add Mac OS X installer that include Java 7
  • SQL Editor Exception when click "Discard Edits" and then click in editor when dialog: "The loaded file is no longer available for editing. Confirm save or discard edits and then clear the SQL editor" is displayed
  • Navigating vertically with arrow keys may change horizontal position if a line holds both TAB and SPACE characters
  • Ctrl+Left-click does not trigger the popup menu
  • Scripts An exception may occur when filtering and expanding/selecting nodes
  • Duplicating file in Scripts tab ruins file extension. "name.sql1" instead of "name1.sql"
  • Drag & drop of file to folder containing a file with the same name gives an error
  • Table Data Editor Unable to save data grid changes when table names containing spaces
  • Force close of an object view tab while saving table data edits may result in an error

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