| Features
Overview |
DbVisualizer
Free
|
DbVisualizer
Personal
|
| 100% Java -> Platform independent. Use the same
tool on any box! |
|
|
 |
| Supports simultaneous database
connections. |
|
|
|
| Connect to a database with a single click! |
|
|
|
| Database
Objects explorer |
|
|
|
| Detailed table/view
information: columns, primary keys, privileges,
indexes, referenced tables (referential integrity
constraints), data, number of rows, etc. |
|
|
|
| Table
Data Filtering |
|
|
|
| Extensive collection of tool
properties that allows setting of data formats,
transaction properties, identifiers, etc. All saved
between invocations of the application. |
|
|
|
| Reverse engineer all referential integrity
constraints and present them in an optimized and animated
graph.
The graph can be displayed based on tables organized in
database connections, schema's, catalogs or a specific
table. Manual layout changes can be saved between
sessions. |
|
|
|
| Export results in HTML or CSV format. |
|
|
|
| Export results in XML or SQL format. |
|
|
|
| Preview and print of references graphs and grids. |
|
|
|
| The SQL
Commander supports execution of arbitrary SQL
statements. |
|
|
|
| Syntax colored SQL
editor with configurable key bindings. |
|
|
|
| Advanced SQL
bookmark functionality. Name and organize your
favorite SQL statements in tree structures. |
|
|
|
| Export and import SQL scripts to and from the file
system. |
|
|
|
| Monitor
feature: execute several SQL bookmarks (select) at a
specified interval. Result is presented in tabs or
windows either as grids (raw data) or as charts
(DbVisualizer Personal only). |
|
|
|
| Dynamic driver
management. No need to bother about environment
settings, CLASSPATH's, etc. Just start DbVisualizer,
load the JDBC drivers or JNDI contexts and relax! |
|
|
|
| Click on a grid column header to sort either in
ascending or descending order. |
|
|
|
| Grid column widths are sized automatically according
to the content. |
|
|
|
| Customize the visible format of Date, Time,
Timestamp, Numbers and nulls. |
|
|
|
| Parameterized SQL statements. Include variable
identifiers in your SQL statement and DbVisualizer will
prompt their values in a form. |
|
|
|
| Position of windows and sizes are saved between
invocations. |
|
|
|
| Choose between three icon collections: Icon.Experience.com,
Java Look and Feel Graphics
and Dean S. Jones.
|
|
|
|
| SQL execution
logging with filtering options. |
|
|
|
| Simple form based table editing capability. |
|
|
|
| SQL script execution |
|
|
|
| Support for multiple
result sets presented as tabs or windows. |
|
|
|
| Support for execution of selected
SQL statements |
|
|
|
| Support for creating multi SQL select scripts. |
|
|
|
| Professional table data charting
capability with export to file option |
|
|
|
| Table editing support using an inline
editor or a form
editor. |
|
|
|
| Support for multiple
SQL editors |
|
|
|
| Support for multiple result sets that are returned
from a single SQL statement (ex. sp_who, sp_help in
Sybase and SQL server) |
|
|
|
| Supports execution of anonymous SQL blocks |
|
|
|
| Test data generator |
|
|
|
| Use drag & drop and folders to structure
database connections |
|
|
|
| Database Objects filtering
|
|
|
|
| Create
Table/Index Assistants |
|
|
|
| Support to view and manage BLOB's and CLOB's. |
|
|
|
|
