/* 14.0 released on 2022-09-20 */

What's new in 14.0

Download for free

/* Quick links */

Release notes > Users guide HTML > Users guide PDF > Other versions >

/* What's new in DbVisualizer */

We're so happy to finally have released DbVisualizer 14! Keep on reading for an overview of the changes.

Please see the release notes for a detailed list of changes.

/* NEW DATABASE SUPPORT */

Support for four new
data sources.

Now supports Cassandra

Apache Cassandra is an open source NoSQL distributed database trusted by thousands of companies for scalability and high availability without compromising performance. Linear scalability and proven fault-tolerance on commodity hardware or cloud infrastructure make it the perfect platform for mission-critical data.

https://cassandra.apache.org

Support for SingleStore

SingleStore is a distributed, highly-scalable SQL database that can run anywhere. We deliver maximum performance for transactional and analytical workloads with familiar relational models.

https://www.singlestore.com

Support for Google BigQuery

BigQuery is a fully-managed, serverless data warehouse that enables scalable analysis over petabytes of data. It is a Platform as a Service (PaaS) that supports querying using ANSI SQL. It also has built-in machine learning capabilities.

https://cloud.google.com/bigquery

Support for Microsoft Access

Access is an easy-to-use tool for creating business applications, from templates or from scratch. With its rich and intuitive design tools, Access can help you create appealing and highly functional applications in a minimal amount of time.

https://www.microsoft.com/en-ww/microsoft-365/access

/* SSH CONFIGURATION */

Refreshed SSH
tunnel setup.

SSH tunnel setup has been redesigned from being defined per individual database connections to a separate feature allowing shared SSH configurations by multiple database connections.

Administration is now a lot easier and the new testing feature eases the burden of understanding why a connection cannot be established.

The connection setup now only shows two settings for SSH, one to select whether to use SSH or not, and another to pick the SSH configuration:

Show database connections associated with an SSH configuration:

View what database connections are using a SSH configuration

It is now easy to test an SSH configuration and browse the log indicating any problems:

/* SSH CONFIGURATION */

Export fixed column
result sets.

Exporting in fixed column width format has been around in the Export Grid functionality for some time. Now we're happy to announce the TXT format is available also for Export Table, Export Schema, and the @export client-side command.

The TXT export output:

/* IMAGE RENDERING */

Images in binary data types can now be rendered in grids.

Viewing images in binary data fields has until now only been possible by individually opening the cell. With the new support, images can be displayed as thumbnails in the grid. The size can be controlled in Tool Properties.

/* COPY DATA-VIEW AS SELECT STATEMENT */

Copy your filtered and sorted Table Data view as a SELECT statement.

A new button to Extract Filter & Sort as SELECT action has been added to the Data tab.

After having filtered and/or sorted the table data in the Data tab, you can use the new button to copy the view as a SELECT statement.

Clicking the button in the above example (a filtered and sorted data tab) generates the following code.

/* AUTO RECONNECT */

Auto reconnect in the SQL Commander.

Now the SQL Commander automatically re-establish the connection with the database in case it is dropped closed while executing a script.

Auto reconnect and execute in SQL Commander

/* And more */

And more improvements
across the board.

Improvement	Description	AFFECTED DATABASES
Runs on Java 17	Java 17 comes bundled with DbVisualizer on all platforms.	All databases
Windows 32-bit	Support for Windows 32-bit removed in 14.0. Use an older DbVisualizer version for Windows 32-bit support.	All databases
SQL Server User Management	Support to create, modify, and drop of users and logins.	MS SQL Server
H2 v2	Support added for H2 version 2.	H2
@command ignore/resume	New @command ignore/resume client side command used to ignore/resume the execution of any client side command.	All databases
@stop now	New @stop now client side command used to stop the execution of the script.	All databases
Batch import as default	Batch importing multiple rows from a database per database request.	All databases
Full script search as default	Make Search Full Script default in SQL History.	All databases

To see all changes in DbVisualizer 14.0, please see the Release Notes.

/* Other versions */

DbVisualizer 14.0

You are currently viewing: 14.0
released on 2022-09-20

Evaluate Pro version

To activate your free 21-day trial,
read more here.

View other versions

Change version

What's new in 14.0