DbVisualizer 8.0.9

DbVisualizer is an intuitive, cross-platform and feature-rich multi-database application useful for database administrators and developers to help them maintain their databases with ease.

Although its name is DbVisualizer, this utility was not designed only for browsing databases.

DbVisualizer will allow develoeprs to use simultaneous connections to many different databases through JDBC drivers.

To use it, all you have to do is to point and click to browse the structure of the database, characteristics of tables, etc. Arbitrary SQL statements may also be executed and saved between sessions.

DbVisualizer comes with support for various databases including Oracle, PostgreSQL, Cloudscape, Sybase, DB2, MySQL, Informix, SQL Server, McKoi, Mimer, SAP DB, and InstantDB.

Here are some key features of "DbVisualizer":

Database Browser:
· Tree based navigation through database objects. View object details and invoke object management features.

Database Object Management:
· Visual support to create, alter and modify characteristics for database objects such as tables. Edit and compile support for procedures, functions, packages and triggers. Extensive database specific support.

Table Data Management:
· Support for editing table data including binary/BLOB and CLOB data types, import from file.
· Tools

SQL Tools:
· SQL editor with support for auto completion, parameterized SQLs, SQL formatter, visual query builder, explain plan, export large result sets. Export DDL for database objects and table data.

Database Server Management:
· DBA features for managing database instance, storage and security parameters in the database server.

Comprehensive Database & OS Support:
· Database specific support: for Oracle, Sybase, SQL Server, PostgreSQL, DB2, Mimer SQL, Neoview, MySQL, Informix, JavaDB/Derby, H2, SQLite.
· Runs on: Mac OS X, Windows, Linux/UNIX.

Requirements:

· Java 1.5 or later
· 10-30 MB disk space depending on installation package
· A minimum of 256 MB RAM
· JDBC 3.0 compliant drivers

Limitations:

· The following features are limited:
· Database specific support for:DB2 for LUW, Informix IDS, JavaDB/Derby, Mimer, MySQL, Oracle, PostgreSQL, SQL Server, Sybase ASE
· Organize database connections in folders
· Database objects filtering
· Sort database connections and folders
· Search database objects
· Show only default database/schema
· Drag and drop support
· Create and Alter table
· Define Referential Integrity Constraints
· Rename Table
· Drop Table
· Create Index
· Create Procedure, Function, Package, Trigger
· Edit Procedure, Function, Package, Trigger
· Execute Procedure, Function
· Export Formats
· Export Table Data
· Custom Data Format Settings
· Support for BLOB, CLOB and binary data
· Save/Load manual layouts
· Table data editing in spreadsheet like editor
· Quick filtering in grids
· Support for BLOB, CLOB and binary data
· View BMP, TIFF, PNG, GIF and JPEG images
· View XML data in tree or text format
· Export Formats
· Custom Data Format Settings
· Support for BLOB, CLOB and binary data
· Expose foreign keys by data selection
· Limit referenced data with filters
· Tag support
· Execute Script
· Execute SQL statement at cursor position
· Execute selected SQL statement(s)
· Execute Explain Plan
· Auto Completion (aka code completion, intellisense)
· Support for multiple SQL editors
· SQL editors displayed as tabs or windows
· Result sets displayed as tabs or windows
· Support for procedures producing multiple result sets
· SQL formatter with extensive customization options
· Editable result sets with the inline or form editors
· Support for BLOB, CLOB and binary data
· View BMP, TIFF, PNG, GIF and JPEG images
· View XML data in tree or text format
· Export large result sets directly to file (@export)
· Design queries with a few mouse clicks
· No SQL expertise is required
· Adopts the generated SQL for the actual database
· Reverse engineer a SELECT statement
· Auto Join of columns by primary/foreign key or name
· Oracle, DB2 for LUW and SQL Server: Explain plan support
· Quick filter with range options
· Show row of Quick filter with range options
· Aggregation Data for Selection
· Permissions checks what commands need confirmation

What's New in This Release: [ read full changelog ]

New Feature:
· General: Add dbvisgui -windowtitle parameter for customization of the DbVisualizer window title

Improvement:
· Chart: Make it possible saving default chart settings between sessions
· General: Increase default max Java memory for DbVisualizer from 256MB to 512MB

Bug:
· Database Objects Tree: Show Table Row Count does not work for tables with mixed case names or names containing reserved characters
· DB Support: DB2 LUW: Source for Procedures, Functions etc. not available when created with CREATE AND REPLACE
· DB Support: SQLite: Need to always treat non-decimal numbers as BIGINT and decimal numbers as DOUBLE to handle large values
· DB Support: SQLite: Export Schema is not available for SQLite
· DB Support: SQLite: Tables are not listed in alphabetic order under the Tables node
· Export: Empty CLOB/BLOB values are represented as NULL when exporting as Value
· General: Using a single right parenthesis as the variable prefix leads to invalid generated SQL
· Import: When importing very large...