New Features
Connection Setup -Support to share a SSH configuration for multiple database connections
Added support for Cassandra
Added support for Google BigQuery
Added support for Microsoft Access
Added support for SingleStore
Improvements
@import - Add the format="xxx" argument for @import
Connection Setup - Automatically reconnect when connection is lost
Connection Setup Security - SSH tunnels can now be used in DbVisualizer Free
DB Support: Azure SQL - Add support to view, create, drop, and change password for users
DB Support: Azure SQL - Introduce a "constraints" sub node to show primary, foreign keys, and referenced tables
*DB Support: SQL Server *- Introduce a "constraints" sub node to show primary, foreign keys, and referenced tables
DB Support: Greenplum - Add support for killing sessions
DB Support: PostgreSQL - Add support for killing sessions
*DB Support: Redshift *- Add support for killing sessions
DB Support: SQL Server - Add support for killing sessions
DB Support: Yellowbrick - Add support for killing sessions
DB Support: H2 - Add support for H2 version 2.x
DB Support: PostgreSQL - Support generating comment statements for triggers
Add support for generated columns in PostgreSQL Create/Alter
DB Support: SQL Server - Add support for create, modify, and drop of users and logins
Data tab - Having a where filter in the Data tab should show a different icon
Driver Manager - Used By column in the driver manager should when clicked show a list of database connections
Add "Reset Driver" command in driver manager
Export - Restrict formatting of numbers for SQL exports
Support exporting in TXT also for @export, Export Table and Export Schema
File Chooser - The choice of "list" or "details" in file choosers should be preserved between DbVisualizer sessions
OS Support: Windows - The choice of "list" or "details" in file choosers should be preserved between DbVisualizer sessions
Filtering/Filter Sets - Make it possible for table filters to be removed after a certain time
General - Make progress windows larger
Change icon for "duplicate" (yellow start) to the standard "copy" icon
Add icon to external web links to highlight that a browser will be opened
Grid Component - Add option to show images in binary type columns in grid
Add "Extract Filter & Sort as SELECT" action in Data tab. Used to copy the SELECT statement in Data tab including any grid column filters and sorting
*Import *- When Batch Import, commit at every executed batch
Make it easy setting data type for the multiple columns during import to new table
Make "Batch Import" default
Java 17 - Bundle Java 17 with installers
Support the ed25519 algorithm for SSH
OS Support: Windows - Remove support for Windows 32-bit
OS Support: macOS - The DbVisualizer window title bar background should follow General / Appearance setting in macOS System Preferences
SQL Commander - Add "@command ignore/resume" to ignore/resume executing any client-side commands
Add the "@stop now" client-side command used to stop the execution of the script
SQL History - Make "Search Full Script" default in SQL History
DbVisualizer is a feature rich, intuitive multi-database tool for developers, analysts and database administrators, providing a single powerful interface across a wide variety of operating systems. With its easy-to-use and clean interface, DbVisualizer has proven to be one of the most cost effective database tools available, yet to mention that it runs on all major operating systems and supports all major RDBMS that are available. Users only need to learn and master one application. DbVisualizer integrates transparently with the operating system being used.
DbVisualizer is available in two versions - the paid version DbVisualizer Pro with complete access to all highly optimized Pro features, and DbVisualizer Free with limited but still powerful functionalities.
DbVisualizer 12.0 works with Caché, InterSystems IRIS with generic database driver.
New Features
Connection Setup -Support to share a SSH configuration for multiple database connections
Added support for Cassandra
Added support for Google BigQuery
Added support for Microsoft Access
Added support for SingleStore
Improvements
@import - Add the format="xxx" argument for @import
Connection Setup - Automatically reconnect when connection is lost
Connection Setup Security - SSH tunnels can now be used in DbVisualizer Free
DB Support: Azure SQL - Add support to view, create, drop, and change password for users
DB Support: Azure SQL - Introduce a "constraints" sub node to show primary, foreign keys, and referenced tables
*DB Support: SQL Server *- Introduce a "constraints" sub node to show primary, foreign keys, and referenced tables
DB Support: Greenplum - Add support for killing sessions
DB Support: PostgreSQL - Add support for killing sessions
*DB Support: Redshift *- Add support for killing sessions
DB Support: SQL Server - Add support for killing sessions
DB Support: Yellowbrick - Add support for killing sessions
DB Support: H2 - Add support for H2 version 2.x
DB Support: PostgreSQL - Support generating comment statements for triggers
Add support for generated columns in PostgreSQL Create/Alter
DB Support: SQL Server - Add support for create, modify, and drop of users and logins
Data tab - Having a where filter in the Data tab should show a different icon
Driver Manager - Used By column in the driver manager should when clicked show a list of database connections
Add "Reset Driver" command in driver manager
Export - Restrict formatting of numbers for SQL exports
Support exporting in TXT also for @export, Export Table and Export Schema
File Chooser - The choice of "list" or "details" in file choosers should be preserved between DbVisualizer sessions
OS Support: Windows - The choice of "list" or "details" in file choosers should be preserved between DbVisualizer sessions
Filtering/Filter Sets - Make it possible for table filters to be removed after a certain time
General - Make progress windows larger
Change icon for "duplicate" (yellow start) to the standard "copy" icon
Add icon to external web links to highlight that a browser will be opened
Grid Component - Add option to show images in binary type columns in grid
Add "Extract Filter & Sort as SELECT" action in Data tab. Used to copy the SELECT statement in Data tab including any grid column filters and sorting
*Import *- When Batch Import, commit at every executed batch
Make it easy setting data type for the multiple columns during import to new table
Make "Batch Import" default
Java 17 - Bundle Java 17 with installers
Support the ed25519 algorithm for SSH
OS Support: Windows - Remove support for Windows 32-bit
OS Support: macOS - The DbVisualizer window title bar background should follow General / Appearance setting in macOS System Preferences
SQL Commander - Add "@command ignore/resume" to ignore/resume executing any client-side commands
Add the "@stop now" client-side command used to stop the execution of the script
SQL History - Make "Search Full Script" default in SQL History
New Features
Added support for Elasticsearch
Added basic support for MongoDB and BSON data viewer
Added support for Presto
Added support for Trino
Driver Manager - Improved the driver management to support download drivers from Maven, version selection, and more
Added an installer for Apple Silicon, M1
SQL Commander/SQL Editor - A new feature to search across all open commander windows
Improvements
Connection Setup -Allow copying the actual database URL from the link
Connection Setup/Driver Manager - Add possibilities to set overridden driver properties centrally
Driver properties with pre-defined list of values should be promoted in a drop-down
Connection Setup SSH - Add support for ssh-agent with SSH Tunnel
DB Support: Exasol - Add "certificate Fingerprint" for Exasol connections
DB Support: Google BigQuery - Add driver entry for Google BigQuery
DB Support: Greenplum - Add "Rename Schema" in PostgreSQL
DB Support: H2 - Add "Rename Schema" in PostgreSQL
DB Support: Netezza - Add "Rename Schema" in PostgreSQL
DB Support: PostgreSQL - Add "Rename Schema" in PostgreSQL
DB Support: Redshift - Add "Rename Schema" in PostgreSQL
DB Support: Snowflake - Add "Rename Schema" in PostgreSQL
DB Support: Yellowbrick - Add "Rename Schema" in PostgreSQL
DB Support: Oracle - Copying a scheduler job can only be created in connection user's schema
DB Support: PostgreSQL - Add "CASCADE" to Truncate
DB Support: SingleStore - Create driver entry and database type for SingleStore
DB Support: Snowflake - Improve support for authenticator=externalbrowser
Database Objects Tree - Give the option (or by default) to color visited table names
Driver Manager - Dynamic OS specific libs should be loaded from driver jar files rather than setting java.library.path
Filtering/Filter Sets - The Database Objects Filters editor should show and allow editing the label1 attribute for DataNodes
Grid Component - Add a "Reset Grid" action to remove any current quick filters, column filters, sorting, and selection
Installation/Update Installation - Should be possible to change the location of included user.vmoptions referenced in dbvis.vmoptions
Installation/Update Installation Web - Remove the UNIX installers, replaced by Linux installers
Performance/Stability - Increase the default value for -Xmx from 768m to 2048m
SQL Commander - Reload of file should preserve current selection, scrolling, and caret position
SSH - Support openssh config behavior to handle append, prepend and removal of algorithms
Scripts - Open multiple script files at once
Bugs Fixed
Driver Manager - Unknown driver properties sent to database
12.1 released on 2021-07-13
Improvements
Database Profile Enable database profiles in DbVisualizer Free
Filtering/Filter Sets
The objects filtering grid should allow re-arranging rows with DnD and new move actions in the right-click menu
General
Add new startup dialog for DbVisualizer Free users
Add new Help->Welcome screen to guide new (and current) users
Provide a demo database with DbVisualizer
Grid Component
Support multi line selection and move rows with DnD and actions in grid columns chooser dialog and also in database objects filter panel
OS Support Windows
Native window decorations and embedded menu bar in Windows 10
OS Support: Windows
Theme: FlatLaf
Add setting to control the embedded toolbar in Windows 10+
OS Support: Windows
Theme: FlatLaf
Tool Properties
Allow setting application font (in addition to the existing grid and editor fonts)
SQL Formatter
Separate format settings for SELECT and DECODE
Scripts
Add capability to mount any directory in the Scripts tab
See the discussion here
Theme
Remove the optional theme selector dialog at startup and the "Ask at Startup" checkbox in the Appearance tool property pane
Theme: FlatLaf
Improve visibility of tab label in dark them using custom background color
Compare
Support compare for explain output in text format
DB Support: Azure SQL
Add support for MFA (ActiveDirectoryInteractive) authentication
Bugs Fixed
DB Support: PostgreSQL
RULE objects are not shown for Tables in PostgreSQL
Compare
Compare grid ignores differences
DB Support: MySQL
Data tab
Data changed in a SQL commander is not visible in the Data Tab
DB Support: PostgreSQL
DDL Generator
Some data views are unavailable when in evaluation mode
Data tab
The visibility of the Data tab filter pane is not preserved at restart
Database Profile: View
DataView could not be created for viewer='xxx'!
DB Support: MySQL
The default useSSL=false driver property is converted by driver to useSSL=true if not explicitly set to false as a parameter at connect
DB Support: Oracle
Stopping an execution in Oracle closes the connection
DB Support: Oracle
Database Objects Tree
When cancelling a database query in a DataView grid, connection may close
DB Support: Redshift
Upgrade the Redshift driver to version 2.0.0.7
Export
Export in XLSX to an existing read-only file doesn't show any error
"The workbook already contains a sheet named X" error when export in Excel format
Export/Import User Settings
Trying to import an invalid file such as Excel in File->Import User Settings results in an error
OS Support: Windows
IllegalStateException: Stopwatch already started
SQL Commander
Reload in the result set tab and then stop while fetching results, yields in no partial result set being displayed
SQL Formatter
Formatting function in SQL editor will alter SQL statements making them incorrect
Cell Viewer/Editor
DEVENV
Java 11
OS Support: Windows
Cursor problem in Cell Editor
DB Support: Exasol
DB Support: Vertica
Query Builder
Autojoin fails to join on FK/PK in Exasol and Vertica
Export
Some files created with "Save as Default" in the export object features are not handled in export/import settings
Query Builder
The elements to JOIN cannot be identified error
Connection Setup
Message when Ping Server is not supported needs to be improved
Connection Setup
DB Support: Greenplum
DB Support: PostgreSQL
DB Support: Redshift
DB Support: Yellowbrick
.pgpass file is not properly reading escaped tokens
Unclear error message when unable to read .pgpass
DB Support: Oracle
Change Password for Oracle is broken since clicking it doesn't show the field for New Password
DB Support: PostgreSQL
Search path is not set when running Explain plan
Importing to new table with "drop existing table" enabled, fails if there is no existing table
DB Support: Snowflake
DDL Generator
View definition is not visible
Import
Selecting data type BLOB/CLOB in import table data prevents it from being changed
Some settings are not loaded from import settings file
SQL Commander
Error opening right-click menu in new SQL Commander tab
SSH
SSH config file parsing is case sensitive
12.0.1
DB Support: Exasol - Update the Exasol JDBC driver to 7.0.4
Bug Fixes
More: https://www.dbvis.com/releasenotes/12.0
DbVisualizer 12.0 works with Caché, InterSystems IRIS with generic database driver.
DbVisualizer 12.0 - support for 6 new databases, a brand new UI and over 90+ improvements:
Support for: Yellowbrick, Greenplum, Microsoft Azure SQL Database, Oracle Cloud, MySQL Cloud, IBM Db2 on Cloud
Now supporting Java 11 on Windows with support for HiDPI monitors
BOM identifiers are now handled in SQL files and during import
SQL Block enclosures
Auto Join
..and much more: https://www.dbvis.com/whatsnew/12.0
DbVisualizer 12.0 - support for 6 new databases, a brand new UI and over 90+ improvements:
Support for: Yellowbrick, Greenplum, Microsoft Azure SQL Database, Oracle Cloud, MySQL Cloud, IBM Db2 on Cloud
Now supporting Java 11 on Windows with support for HiDPI monitors
BOM identifiers are now handled in SQL files and during import
SQL Block enclosures
Auto Join
..and much more: https://www.dbvis.com/whatsnew/12.0
This is not the first release - DbVisualizer has been available online since 2003. These are the 11.0 release notes:
https://www.dbvis.com/releasenotes/11.0