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

    What's new in 14.0

    /* 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:

    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.
    /* 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.2
    released on 2022-11-23

    Evaluate Pro version

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

    Notify me when new features are announced