DbVisualizer
DbVisualizer is developed in its current version 12.1 after more than ten years of interaction with commercial customers. By any standard, DbVisualizer is successful, with 23,500 client organizations in 143 countries, ranging from self-employed consultants to major institutions and global companies, some of which have more than 8,000 licenses.
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.
One tool for all databases and OSes
DbVisualizer is the ultimate database tool for developers, analysts and DBAs. It runs on all major OSes and connects to all major databases.
What's new in release 12.1
Database profiles in DbVisualizer Free
A database profile in DbVisualizer is specific for each supported database and defines what database objects are supported, the actions to operate on them, and what viewers are available. To prepare for some really interesting future updates, we're happy to announce that database profiles are now available DbVisualizer Free.
The following sample is for Oracle showing how it used to look (left) and with the change in the new version (right).
Native window decorations and embedded menu bar in Windows 10
DbVisualizer now adjusts the window decorations to match the current light or dark theme. The main menu bar is now also embedded (configurable) with the window title to comply with the most recent look and feel in Windows.
Add capability to mount any folder in the Scripts tab
A new option in the Scripts tab is to mount remote file folders. This is useful when having script files in for example DropBox, Google Drive, OneDrive, and other network folders.
Bundled demo database
To get up and running quickly, there is a new bundled demo database in DbVisualizer. This uses the embedded H2 database and comes with a full schema, including data and sample scripts. Use the demo database to quickly get started and explore the feature set in DbVisualizer.
Install it using Help->Install Demo DB and Samples.
Application Font
It is now possible to control application font in addition to Grid and Text Editor settings.
... and more
12.1.2 released on 2021-08-25
Bugs Fixed
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
12.1.1 released on 2021-07-23
Bugs Fixed
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'!
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 pane
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
Theme
Remove the optional theme selector dialog at startup and the "Ask at Startup" checkbox in the Appearance tool property pane
Bugs Fixed
DB Support: PostgreSQL
RULE objects are not shown for Tables in PostgreSQL