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 and Firebird.
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
Free versus licensed |
Lite |
Basic |
Professional |
Enterprise |
| 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 |
Lite |
Basic |
Professional |
Enterprise |
| 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 |
Lite |
Basic |
Professional |
Enterprise |
| 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 |
Lite |
Basic |
Professional |
Enterprise |
| Logical Data Model diagramming |
|
|
|
|
| Generate DBMS specific physical models from a single logical 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 |
Lite |
Basic |
Professional |
Enterprise |
| Unicode enabled source code & SQL editors |
|
|
|
|
| Connect to multiple databases at once |
|
|
|
|
| Ability to browse database and schema objects |
|
|
|
|
| Ability to view, create, modify and delete individual database and schema 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 |
|
|
|
|
| Execute queries and scripts in an interactive editor |
|
|
|
|
| Execute very large scripts in special Script Runner |
|
|
|
|
| Duplicate object capability |
|
|
|
|
| Create CRUD (SUID) Procedures |
|
|
|
|
| Search schema objects by name |
|
|
|
|
| Comprehensive search of source code objects |
|
|
|
|
| Session Script Recorder |
|
|
|
|
| View object dependencies |
|
|
|
|
Testing & Debugging |
Lite |
Basic |
Professional |
Enterprise |
| 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 3 |
|
|
|
|
| Trigger Debugging 4 |
|
|
|
|
| Package Debugging 5 |
|
|
|
|
Data import and export, compare and transfer |
Lite |
Basic |
Professional |
Enterprise |
| 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 |
Lite |
Basic |
Professional |
Enterprise |
| 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 |
Lite |
Basic |
Professional |
Enterprise |
| 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 |
Lite |
Basic |
Professional |
Enterprise |
| 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 |
|
|
|
|
| External tools accessible via configurable menu items |
|
|
|
|
Workspace/Project |
Lite |
Basic |
Professional |
Enterprise |
| 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 |
Lite |
Basic |
Professional |
Enterprise |
| 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) |
Lite |
Basic |
Professional |
Enterprise |
| 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
- 3. Available for Oracle, MySQL, PostgreSQL, Firebird and InterBase
- 4. Available for MySQL, Firebird and InterBase
- 5. Available for Oracle and Firebird