| DbVisualizer description |
Download |
 |
|
DbVisualizer is a database tool useful for developers and database administrators to aid maintaining their databases. It is the perfect choice since the same tool can be used on all major operating systems accessing a wide range of databases. Even though the name spells DbVisualizer it is not only for browsing databases.
DbVisualizer will enable simultaneous connections to many different databases through JDBC drivers.
Just point and click to browse the structure of the database, characteristics of tables, etc. Arbitrary SQL statements can be executed and saved between sessions. DbVisualizer supports a variety of databases including Oracle, Sybase, DB2, MySQL, Informix, SQL Server, PostgreSQL, Cloudscape, McKoi, SAP DB, Mimer and InstantDB.
Here are some key features of "DbVisualizer":
· Edit table data
· Auto Completion support in the SQL editors
· Create/Alter Table support
· Execution of SQL scripts
· Multi result set management
· Charting of data
· Management of BLOB/CLOB data
· Query Builder
· Data Navigator
· Explain plan support
· Browse views, triggers, summary tables, synonyms, functions, procedures, system tables, triggers, columns primary keys, privileges, constraints, references, DDL, program, modules, data files, table spaces, etc.
Requirements:
· Java 1.5 (Java 1.6 is also supported)
· 10-30 MB disk space depending on installation package
· A minimum of 256 MB RAM
· JDBC 3.0 compliant drivers
|
What's New in This Release:
· DB Support: Informix - Separate system procedures and functions from user created procedures and functions in the objects tree
· Export - Default format for numeric types in Export should be "Unformatted"
· General - Re-introduce the pre 4.2 backward compatibility support so that old user settings files is loaded properly
· Bug Fix: DB Support: DB2 - NullPointerException when executing SQL if the database connection is lost
· Bug Fix: DB Support: PostgreSQL - Invalid FK clause in DDL for some tables
· Bug Fix: DB Support: Sybase ASE - The DDL tab results in an error for Sybase versions prior to 12
· Bug Fix: General - String auto-quoting truncates values for "[NOT] IN" conditions when quoted values contain delimiter characters (e.g., space)
· Bug Fix: Navigator - Delete Selected Node is enabled even when no node is selected, and gives NullPointerException if clicked
· Bug Fix: Navigator - The grid for a related table show incorrect values if the source table has been sorted
· Bug Fix: SQL Commander - Any string starting with "go" is interpreted as the "go" delimiter ... [
read full changelog ]