| DbVisualizer Pro |
DbVisualizer Free |
||
|---|---|---|---|
Supported OS'es |
|||
| » Runs on Windows, Mac OS X, and Linux/UNIX | |||
| » Configurable key bindings with pre-defined key maps | |||
| » Look & Feels for Windows, Mac OS X, Linux/UNIX | |||
| » GUI and Archive installers with option to install JavaVM | |||
The DbVisualizer UI |
|||
| » Rearranging Tabs using drag&drop | |||
| » Maximize Tabs with double-click | |||
| » Detach tab in separate Window | |||
| » Pin tabs | |||
| » Tile/Collapse all tabs in a tab group | |||
| » Specify default naming scheme for tabs | |||
| » Rename individual tabs | |||
| » Save layout of Object View tabs between DbVisualizer sessions | |||
Task Management and Memory Monitoring |
|||
| » Central Task Manager | |||
| » Memory Monitor warns about high memory usage | |||
Connection Management |
|||
| » Dynamic JDBC driver management (no CLASSPATH editing) | |||
| »
JDBC drivers included with DbVisualizer DB2 for LUW H2 JavaDB/Derby Mimer SQL MySQL PostgreSQL Oracle SQLite SQL Server Sybase SQL Anywhere Sybase ASE |
|||
| » SSH support with known_hosts and private key support | |||
| » Step-by-step connection setup with a wizard | |||
| » Organize database connections in folders | |||
| » Set individual tab background color and borders for each connection | |||
| » Parameterized connection data | |||
| » Supports multiple simultaneous open database connections | |||
| » Connect a single or multiple connections with a single click | |||
| » Export and Import connections and general user settings | |||
Database Browser |
|||
| » A tree structure to browse and manage database objects | |||
| » Multi-object support for open, connect, drop, etc | |||
| »
Database specific support for DB2 for LUW Informix IDS H2 JavaDB/Derby Mimer SQL MySQL Oracle PostgreSQL SQLite SQL Server Sybase ASE |
|||
| » Generic database support | |||
| »
View basic information for tables, indexes, primary keys, privileges, schemas, databases, procedures and a lot more |
|||
| » Type-to-find objects by name | |||
| » Database objects filtering | |||
| » Sort database connections and folders | |||
| » Search database objects | |||
| » Show only default database/schema | |||
| » Organize database connections and folders with drag&drop | |||
| » Script multiple database objects using drag&drop | |||
Table
|
|||
| » Create and Alter table | |||
| » Define Referential Integrity Constraints | |||
| » Rename Table | |||
| » Drop Table | |||
| » Empty Table | |||
| » Create Index | |||
| » Table DDL viewer | |||
Procedure, Function, Package and Trigger
|
|||
| » Create Procedure, Function, Package, Trigger | |||
| » Edit Procedure, Function, Package, Trigger | |||
| » Execute Procedure, Function | |||
Export Schema/Database
|
|||
| » Export Formats | CSV, HTML, SQL, XML, XLS, XLSX, JSON | ||
| » Export object DDLs | |||
| » Export Table Data | |||
| » Custom Data Format Settings | |||
| » Support for BLOB, CLOB and binary data | |||
References Graphs |
|||
| » Graph or list of referential integry rules | |||
| » Several automatic graph layout managers | |||
| » Link table nodes by foreign keys | |||
| » Link table nodes by all columns in a foreign key | |||
| » Bridge link support to improve readability | |||
| » Graph zooming, fit, animation and navigator pane | |||
| » Show Table details | |||
| » Script Tables as SQL by SELECT, INSERT, CREATE, etc. | |||
| » Export and print | |||
| » Save/Load manual layouts | |||
Table Data Viewer/Editor |
|||
| » Table data editing in grid (spreadsheet) editor | |||
| » Table data editing in form editor | |||
| » Auto-complete column names while specifying inline filter | |||
| » Table filters saved between sessions | |||
| » Copy/Paste with external spreadsheet tools such as Excel | |||
| » Quick filtering in grids | |||
| » Display references to other tables | |||
| » Monitor row count differences | |||
| » Support for BLOB, CLOB and binary data | |||
| » View BMP, TIFF, PNG, GIF and JPEG images | |||
| » View PDF documents | |||
| » View XML data in tree or text format | |||
Table Export |
|||
| » Export Formats | CSV, HTML, SQL, XML, XLS, XLSX, JSON | ||
| » Export CREATE DDL for SQL format | |||
| » Export INDEX DDL for SQL format | |||
| » Custom Data Format Settings | |||
| » Support for BLOB, CLOB and binary data | |||
Table Data Import |
|||
| » Import table data from CSV files | |||
| » Support for BLOB, CLOB and binary data | |||
| » Support multi-character column separator | |||
| » Automatic data type detection | |||
| » Automatic mapping of file columns to table columns | |||
| » Create table from imported data | |||
| » Save settings between sessions | |||
Data Navigator |
|||
| » Expose foreign keys by data selection | |||
| » Limit referenced data with filters | |||
| » Tag support | |||
| » Edit table data directly in Navigator | |||
SQL Editor |
|||
| » Execute Script with a single SQL statement | |||
| » Execute Script with multiple SQL statements | |||
| » Execute single SQL statement at cursor position | |||
| » Execute selected SQL statement(s) | |||
| » Execute Buffer (as a single SQL statement) | |||
» Execute Explain Plan
|
|||
| » Syntax colored SQL editor | |||
| » Auto Completion (aka code completion, intellisense) | |||
| » Support for multiple SQL editors | |||
| » SQL editors displayed as | Tabs or Windows | Tabs | |
| » Result sets displayed as | Tabs or Windows | Tabs | |
| » 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 PDF documents | |||
| » View XML data in tree or text format | |||
| » Export result sets with Create Table option | CSV, HTML, XLS, XLSX, XML, SQL | CSV, HTML | |
| » Export large result sets directly to file (@export) | |||
| » Parameterized SQL queries | |||
| » Supports objects dragged from the Database Browser | |||
| » Drop files from Desktop or external tools | |||
| » SQL execution logging with filtering options | |||
| » Pre-defined editing key maps | |||
| » Merge Result Sets in Text Format | |||
Query Builder |
|||
| » Design queries with a few mouse clicks | |||
| » No SQL expertise is required | |||
| » Adapts the generated SQL for the actual database | |||
| » Reverse engineer a SELECT statement | |||
| » Auto Join of columns by primary/foreign key or name | |||
Explain Plan
|
|||
| » Browse plan data in graph view
|
|||
| » Browse plan data in tree view
|
|||
| » Coloring based on node cost
|
|||
| » Export/Copy plan data
|
|||
SQL History |
|||
| » SQL History | |||
| » Limit number of history entries to save | |||
| » Filter by full script content | |||
SQL Bookmarks |
|||
| » Organize bookmarks in a folder structure | |||
| » Save bookmark as favorite for efficient access | |||
Charts |
|||
| » Supports Line, Area, Bar, Point, Pie, Stacked Area, Stacked Bar | |||
| » Modify serie label without need to use column aliases in select | |||
| » Set chart, X-axis and Y-axis titles | |||
| » Pre defined color schemes | |||
| » Optional legend at top, bottom, left or right | |||
| » Zooming, Export, Print | |||
| » Export | PNG, JPEG, GIF | ||
| » Copy chart image to system clipboard | |||
Favorites |
|||
| » Display database object details with a single-click | |||
| » Load bookmark scripts in current or new editor | |||
| » Organize favorites with drag and drop | |||
Monitor |
|||
| » Instant Monitor of results from SQL | |||
| » Automatic monitoring of any result set | |||
| » Single view of result sets from multiple databases | |||
| » View data in grid, text or professional charts | Grid, Text, Chart | Grid | |
| » Print and export monitored data | |||
Result Set Management |
|||
| » Auto resize columns, manual column resizing | |||
| » Double click column divider to sort column | |||
| » Re-arrange columns by drag and drop | |||
| » Multi colum sort by clicking column header | |||
| » Copy column name | |||
| » Copy selection | |||
| » Quick filter with range options | |||
| » Quick filter highlights matched cells | |||
| » Aggregation Data for Selection | |||
| » Find cell data and column name | |||
| » Export grid data | CSV, HTML, XLS, XLSX, XML, SQL, TEXT, JSON | CSV, HTML | |
Compare |
|||
| » Compare texts | |||
| » Compare grids | |||
Configurable |
|||
| » Define your own key bindings | |||
| » Pre-defined key bindings for TOAD and SQL Server Analyzer | |||
| » Set unique properties per database connection | |||
| » Permissions checks what commands need confirmation | |||
| » Customize the format of Date, Time and Numbers | |||
| » Set fonts | |||
| » And a lot more... | |||
Customer Testimonial:
More...
We have used dbVisualizer for a while now, and could not live without it. The product is outstanding and rich, and does neither too much nor too little. The ability to export to Excel is also one of those features I happened upon and think is great. The product just gets better and better, and...Tom Harrison
More...
