| Features Overview |
|
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. |
|
|
|
