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.
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.
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.
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.
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 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.
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.
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