DbVisualizer 9.0.6 Build 1928

DbVisualizer - A database tool useful for developers and database administrators to aid maintaining their databases

A database tool useful for developers and database administrators to aid maintaining their databases

DbVisualizer is the perfect choice since it can also 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 features :

- Supports multiple simultaneous database connections
- Connect to a database with a single click
- Database objects explorer
- View information for: tables, indexes, primary keys, privileges, schemas, databases, procedures and a lot more
- View referential integrity rules in a graph or list
- Organize database connections in folders
- Database objects filtering
- Search database objects
- Support for BLOB, CLOB and binary data
- View BMP, TIFF, PNG, GIF and JPEG images
- View XML data in tree or text format
- Import table data from CSV files
- Syntax colored SQL editor
- Auto Completion (aka code completion, intellisense)
- Support for multiple SQL editors
- Support for multiple result sets SQL's
- 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
- Execution control (stop on error/warning)
- View result sets as grid, text or chart Grid, Text, Chart, Grid
- 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 result sets with Create Table option CSV HTML XLS XML SQL TEXT CSV HTML
- Batch execution enabling export of large result sets
- SQL history saved between sessions
- Advanced SQL bookmark functionality
- Sort by clicking column header
- Simple calculations on data
- Parameterized SQL queries
- Drop objects dragged from the Objects Tree
- Support for execution of selected SQL statements
- Execute SQL statement at cursor position
- SQL execution logging with filtering options
- Support for creating multi SQL select scripts
- Pre-defined key maps
- Oracle, DB2 and SQL Server: Explain plan support
- Oracle: Support for the XML data type


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

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

DbVisualizer 9.0.6 Build 1928 is licensed as Demo for the Windows operating system / platform. DbVisualizer is provided as a free to try download for all software users (Demo).