Database Workbench available editions and feature matrix
Available Editions
Database Workbench 6 is available in four editions:
Database Workbench Lite * | A FREE edition of Database Workbench that supports a single database system and a basic set of features, for personal, non-commercial development only.
If you use Database Workbench for commercial development, please support us by purchasing a license so we can continue product development. |
Database Workbench Basic | A basic starter edition, suitable for software developers that create and use databases. |
Database Workbench Professional | A complete edition for database developers and designers, for more complex databases, including testing and debugging tools. |
Database Workbench Enterprise | A special team edition, with the ability to use shared repositories for server and database registrations, specific multi-user features and a built-in Version Control System for database objects. |
* = available for MySQL.
Below is a feature matrix, not meant as a guide to all features, but rather as a guide to the differences between the available editions.
Feature Matrix
Feature | Lite | Basic | Pro | Ent |
Free versus licensed | ||||
Commercial database development | ||||
Ability to register more than 2 servers | ||||
Ability to register/use more than 2 databases per server | ||||
Ability to use multiple database systems | ||||
Ability to open SQLite databases (without SQLite module license, meta data read only) 1 | ||||
Support for Windows roaming user profiles | ||||
Support for Windows Terminal Server 2 | ||||
Connect to Database Workbench TeamServer | ||||
ODBC & ADO Tools | ||||
Ability to open MS Access databases (meta data read only) | ||||
Ability to connect to any ODBC & ADO data source (meta data read only) | ||||
Export data from any ODBC & ADO data source | ||||
Create INSERT script from any ODBC data source | ||||
Cross-Database development | ||||
Compare meta data objects, also from different database systems | ||||
Migrate meta data objects to the same or different database systems | ||||
Migrate meta data objects from any ODBC & ADO data source | ||||
Database design | ||||
Conceptual Data Model diagramming | ||||
Generate DBMS specific physical models from a single conceptual model | ||||
Physical Data Model diagramming | ||||
Create a new database directly from a physical model | ||||
Export a diagram to image file | ||||
Reverse engineer existing databases to a physical model for documentation purposes | ||||
Database development | ||||
Unicode enabled | ||||
Connect to multiple databases at once | ||||
Ability to browse schema objects | ||||
Ability to browse database objects | ||||
Ability to view, create, modify and delete individual schema objects | ||||
Ability to view, create, modify and delete individual database objects | ||||
Two-Way Visual Query Builder | ||||
Edit and view data | ||||
Edit and view BLOB Data as images, OLE, PDF, DOC and DOCX documents, text, HTML and hex-data | ||||
Extract metadata statements for existing objects | ||||
Run queries and scripts in an interactive editor | ||||
Run very large scripts in special Script Runner | ||||
Duplicate object capability | ||||
Create SUID Procedures | ||||
Search schema objects by name | ||||
Comprehensive search of source code objects | ||||
Session Script Recorder | ||||
View object dependencies | ||||
Testing & Debugging | ||||
Execute SQL statements and verify changes before committing | ||||
Execute stored routines and verify changes before committing | ||||
Simple Test Data Generator tool | ||||
Visually analyze query plans | ||||
Stored Procedure & Function Debugging 2 | ||||
Trigger Debugging 3 | ||||
Package Debugging 4 | ||||
Data import and export, compare and transfer | ||||
Export result sets to INSERT, UPDATE or DELETE scripts | ||||
Export data to INSERT script and XML files | ||||
Export data to CSV files | ||||
Export data to dBase, Text, Excel, Lotus 1-2-3 and DIF files | ||||
Create INSERT script from any ODBC data source | ||||
Import data from CSV file | ||||
Data Pump tool to transfer to and from supported native data sources | ||||
Data Pump tool to transfer to and from any OBDC & ADO data source | ||||
Command line Data Pump tool to transfer data | ||||
Data Compare tool to compare and update data in supported native data sources | ||||
Server & Database administration | ||||
Perform database administrator tasks | ||||
Perform server administrator tasks | ||||
Manage users, roles and groups | ||||
Monitor activity and performance via visual user interface | ||||
Grant Manager tool to visually manage SQL grants, including "grant templates" | ||||
Ability to manage grants in object editors | ||||
Printing | ||||
Print source code | ||||
Print table data or query result sets | ||||
Print schema objects | ||||
Create database specific custom reports | ||||
Create file based custom reports that can be used on multiple databases | ||||
Productivity | ||||
Use object templates | ||||
Use code templates | ||||
SQL Insight | ||||
Special Copy/Paste SQL statements from/to your programming environment | ||||
Describe Companion for easy access to object structure | ||||
Drag & drop features for code editing | ||||
Incremental search in the Database Navigator | ||||
Filter objects in the Database Navigator | ||||
Text (File) Compare tool | ||||
Multi-Level Clipboard | ||||
Personal SQL & Code Catalogs to store common queries & code | ||||
'Favorites' list for quick & easy access to databases & connections | ||||
Workspace/Project | ||||
Arrange database objects in custom folders | ||||
Add notes to a database workspace | ||||
Integrated To-Do Lists to keep track of work | ||||
Project based SQL & Code Catalog | ||||
TeamServer | ||||
Shared repository with registered servers and databases | ||||
Non-local workspace, use the same workspace on multiple clients | ||||
Team-based To-Do Lists | ||||
Shared SQL & Code Catalogs to store common queries & code | ||||
TeamServer Version Control System (VCS) | ||||
Ability to add databases to TeamServer VCS | ||||
Lock database objects for editing | ||||
Automatically archive new meta-data structure on 'check in' | ||||
Ability to compare archived revisions of database objects |
Notes
- 1. Full support for SQLite is available if you have a licensed SQLite module
- 2. Not available in Trial version
- 2. Available for Oracle, SQL Anywhere, MySQL, PostgreSQL, Firebird and InterBase
- 3. Available for MySQL, Firebird and InterBase
- 4. Available for Oracle and Firebird