14.0 released on 2022-09-20

    What's new

    You are currently viewing an old version of DbVisualizer. We recommend that you check out our latest 23.2.5 version.
    /* Quick links */
    Release notes -> User guide HTML -> User guide PDF -> Download 14.0.4 -> 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.

    SSH Configurations

    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:

    SSH setup for a database connection

    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:

    Database connections using SSH configuration
    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.

    TXT export

    The TXT export output:

    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.
    Images in resultset
    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.

    Filtered data

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

    Generated SQL
    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
    View all versions ->
    Notify me when new features are announced