-
Latest Version
DbVisualizer 24.2.2 LATEST
-
Review by
-
Operating System
Windows 7 64 / Windows 8 64 / Windows 10 64 / Windows 11
-
User Rating
Click to vote -
Author / Product
-
Filename
dbvis_windows-x64_24_2_2.exe
Supported Databases
Amazon Redshift, DB2 LUW, Derby, Exasol, H2, Informix, Microsoft SQL Server, Mimer SQL, MySQL, Netezza, NuoDB, Oracle, PostgreSQL, SQLite, Sybase ASE, and Vertica.
Runs Everywhere
Db Visualizer 64 bit runs on all the major platforms, Windows, macOS, and Linux.
SQL Tools
SQL editor with support for auto-completion, parameterized SQLs, SQL formatter, visual query builder, explain plan, and, a command-line based interface.
Database Browser
Tree-based navigation through database objects. Multiple objects can be displayed side-by-side.
Object Management
Visual tools to manage database objects. Edit, compile, and, run procedures, functions, triggers, and, a lot more.
Table Data Management
Spreadsheet-like table data editor including binary/BLOB and CLOB data types, import from CSV, and Excel files.
Export
Export database objects and table data as CREATE/INSERT statements, CSV, XML, and more. Support for exporting the very large result
DbVisualizer is tested with the major databases and JDBC drivers. For databases more commonly used in the industry, It has added support for database-specific features. Key bindings are configurable and the appearance of the application is highly customizable. Some of these features are:
- Management of database-specific objects
- Visual actions for CREATE, ALTER, DROP, RENAME and so on
- Create, Edit and Compile procedures, functions, and triggers
- Explain plan support
- Schema Export
- Compare of editors and result sets
- ...and much more
Also Available: Download DbVisualizer for Mac
What's new in this version:
DbVisualizer 24.2.2
Improvements:
SQL Commander:
- Display execution duration in the tooltip of the result tab
Fixed:
- 'Max Rows" should not be applied to updates within undelimited statement blocks in SQL Server
- Exception in "Drop Package"
- "Alter Table" doesn't work for certain versions of MariaDB and SingleStore
- Error when saving stored procedures in Redshift for certain driver versions
- PRINT statements are not always reported in the Log tab
- Exception when generating column constraints in SQLite in certain cases
- "Create Sequence" generates incorrect SQL in Snowflake
- Function DDL may be incomplete in Snowflake
- JSON values are interpreted as parameter markers in Snowflake
- "Quote Text Value" is not set correctly when loading export settings
- Column type is set to "Custom" when exporting numbers to Excel
- The choice of font may be lost after application restart
- Package navigator does not show all procedures/functions
- Not able to save procedures and functions for some languages
- Table and columns names are not always qualified properly in Query Builder
- Rows in the "Conditions" tab in Query Builder may be clipped
- Error in the generated HAVING clause in Query Builder
- Possible visual artifacts when hovering the "Sticky" control in SQL Commander
- Actions in the "Find and Replace Toolbar Actions" category are not listed correctly in the key bindings editor
- Availability check for Maven repositories in Tool Properties doesn't work when a proxy is used
- Possible exception on application start when checking OS theme settings
DbVisualizer 24.2.1
- Change log not available for this version
DbVisualizer 24.2
New Features:
- Add support for creating persistent database connections using dbviscmd
- Add support for Azure Synapse Analytics
- Add support for the Cassandra JDBC Wrapper driver
- Add basic support for Databricks
- Navigate between procedures and functions in the package body editor
- Add support for generating MERGE statements when exporting data as SQL
- Add support for trimming text values when exporting data
- Add actions to select the previous/next statement in the editor (Ctrl+Alt+Up/Down)
- Automatic theme switching
- New dark and light themes
- Introduce new scalable icons
- Automatically qualify columns when the column name alone is ambiguous
- Add support for SVG images in the cell viewer and the data grid
- Improve the response to "PKIX path building failed"
- Add support for generated columns in MySQL in Create/Alter Table
- Add support for sequence name in auto-generated columns in PostgreSQL
- DB Support: Greenplum Add support for Greenplum 7
- DB Support: Greenplum
- DB Support: PostgreSQL
- DB Support: Redshift
- DB Support: Yellowbrick Display table constraints under the corresponding table node in the database objects tree
- DB Support: PostgreSQL Add support for roles in PostgreSQL (replacing users and groups)
- DB Support: Redshift Add support for materialized views in Redshift
- DB Support: Snowflake Handle additional table types in Snowflake (dynamic, event, hybrid and iceberg tables)
- Database Objects Tree In the database objects tree, add an indicator to nodes where all sub-nodes were hidden by an active filter
- Export Use SQL syntax highlighting in the preview section in Export Grid
- Automatically suggest file extensions when exporting data
- General Improved support for arrays
- Grid Component Display newlines and tabs as symbols rather than whitespace in text values in the data grid
- Multi-thread image preview generation
- SQL Commander With auto-commit off, show the actual statements when warning the user about uncommitted updates
- Add support for a list of choices in custom variables
- SQL Editor Add a button for newline in Find and Replace
- Support newline, tab and uppercase/lowercase manipulation in Find and Replace
- Handle identifier delimiters based on database type instead of user configuration
- Security Add the option to reset master password also when a master password is required
Fixed:
- Area Details
- Auto-Completion Auto-Completion may fail when operators are used in the SELECT clause
- Auto-completing a column in a sub-select may insert an alias from the outer query
- Auto-completion doesn't work after INSERT INTO
- Auto-completion doesn't work with the USING join syntax
- The auto-completion popup may behave strangely if a database error occurs when loading table metadata
- Create/Alter Table
- DB Support: PostgreSQL NOT NULL can be omitted in the DDL for auto-generated columns in PostgreSQL
- DB Support: ClickHouse Can't list databases in older versions of ClickHouse
- DB Support: Exasol Incorrect SQL generated by the "Create User LDAP" action in Exasol
- Export/Import User Settings Passwords are not included when exporting/importing SSH configurations
- Key Bindings Some of the assigned key combinations may stop working until the application is restarted
- OS Support: macOS Expanding database nodes using the keyboard may result in the spinning beachball on macOS Sonoma
- Query Builder When loading a query containing an unsupported operator into the query builder, it is replaced with "="
- SQL Commander "Enter Data for Variables" dialog does not reflect the initial state of boolean variables
- SQL Editor Multi-caret select may exclude the first line when clicking outside of the editor
- The delete key doesn't work in multi-caret mode
- Tool Properties "Show Password" doesn't work for authentication type Public Key in Tool Properties->SSH Configurations
- AvastAvast Free Antivirus 24.9.9452.0
- 4K Download4K Video Downloader+ 1.9.1 (64-bit)
- PhotoshopAdobe Photoshop CC 2024 25.12 (64-bit)
- PC RepairPC Repair 1.0.3
- OperaOpera 114.0 Build 5282.21 (64-bit)
- Adobe AcrobatAdobe Acrobat Pro 2024.003.20180
- BlueStacksBlueStacks - Play on PC 5.21.580
- Hero WarsHero Wars - Online Action Game
- TradingViewTradingView - Trusted by 60 Million Traders
- AnyRecoverAnyRecover 6.3.2
Comments and User Reviews