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.
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: [ read full changelog ]
Improvement:
· OS Support: Support for Windows 7
· OS Support: Add installer for Windows x64
Bug:
· DB Support: DB2 z/OS - Some DB object types are displayed for all schemas instead of the selected
· DB Support: MySQL - An explicitly declared 0 default for a not-nullable int column is not preserved in the generated DDL
· DB Support: Oracle - (null) appear as table space name in "Remove Datafile" action
· DB Support: Oracle - Incorrect index column order in objects tree
· DB Support: PostgreSQL - Incorrect FK declarations generated in DDL when multiple FKs to/from the same table has the same name
· DB Support: PostgreSQL - The Table and Column lists for the Referenced Table FK constraints in the Create/Alter Table dialog contains too many entries
· Explain Plan - Explain plan feature for Oracle doesn't properly quote the schema and PLAN_TABLE names
· General - Fix regression problem with connection being timed out
· SQL Commander - Java 1.6: Focused component is not restored when jumping between the Object View and SQL Commander tabs
· SQL Formatter - Comments after the last statement are removed when formatting
· [http://minq.se/forum/thread.jspa?threadID=2771]
· Table Data Editor - An error occur in the form data editor and if selecting another object in the objects tree or disconnect/refresh