Slogan: database tools for developers
Company Logo: Upscene Productions

Database Workbenchtm

Feature Matrix

Database Workbench is available in two editions:

  • Database Workbench Lite: the FREE edition of Database Workbench that supports a single database system and a basic set of features.
  • Database Workbench Pro: the complete edition of Database Workbench that has all features and can support multiple database systems.

Below is a list of the feature differences between the editions:

Feature Pro Lite
Pro versus Lite
Ability to register more than 3 servers
Ability to register/use more than 5 databases per server
Cross-Database development
Ability to use multiple database systems
Ability to connect to any ODBC & ADO data source
Migrate meta data objects to the same or other database systems
Migrate meta data objects from any ODBC & ADO data source
Export data from any ODBC & ADO data source
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 documents, text, HTML and Hex-data
Run queries and scripts
Extract metadata statements for existing objects
Duplicate object capability
Create SUID Procedures
View dependencies
Search schema objects by name
Comprehensive search of source code objects
Session Script Recorder
Database design
Conceptual Data Model diagramming
Physical Data Model diagramming
Generate DBMS specific physical models from a single conceptual model
Reverse engineer existing databases to a physical model diagram
Testing & Debugging
Execute SQL statements and verify changes before committing
Execute stored routines and verify changes before committing
Visually analyze query plans
Test Data Generator tool
Stored Procedure & Function Debugging 1
Trigger Debugging 2
Package Debugging 3
Data import, export and transfer
Export data to INSERT script and XML files
Export data to dBase, Text, Excel, CSV, Lotus 1-2-3 and DIF files
Script INSERT statements from an ODBC data source
Import data from CSV file
DataPump tool to transfer to and from supported native data sources
DataPump tool to transfer to and from any OBDC & ADO data source
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"
Printing
Print source code
Print table data or query result sets
Print schema objects
Productivity
Use object templates
Use code templates
SQL Insight
Special Copy/Paste from/to your programming environment
Text File Compare tool
Describe Companion for easy access to object structure
Multi-Level Clipboard
SQL & Code Catalogs to store common queries & code

Notes

  1. Available for Oracle, Sybase SQL Anywhere, Firebird and InterBase
  2. Available for Firebird and InterBase
  3. Available for Oracle