Database Workbench is a powerful tool to help in developing database applications.
It has numerous tool to create and modify, query and test, manage and control your databases
at multiple servers and multiple types of database engines, all from a single and consistent user interface.
Although Database Workbench supports multiple types of database engines, it is by no means a "generic" tool -
with Database Workbench, you have access to server specific features, ranging from license management to specialized
Depending on your license, you might or might not have access to certain types of database engine and screenshots
in this help will differ from the actual program used by you. In general, however, everything stays the same.
The tools will work the same for all database engines supported.
Currently supported database engines are:
- Borland InterBase - www.borland.com/interbase - see Database Workbench & InterBase Versions: 4.x, 5.x, 6.x, 7.x, 2007 and 2009.
- Firebird, Open Source - www.firebirdsql.org - see Database Workbench & Firebird Versions: 1.0, 1.5, 2.x
- Microsoft SQL Server - www.microsoft.com/sql/ - see Database Workbench & MS SQL Server Versions: 7, 2000, 2005, 2008, MSDE 1, MSDE 2, SQL Express 2005 & 2008
- MySQL, Open Source - www.mysql.com - see Database Workbench & MySQL Versions: 4, 4.1, 5.x
- Oracle Database - www.oracle.com/database - see Database Workbench & Oracle Versions: 8i, 9i, 10g and 11g
- NexusDB - www.nexusdb.com - see Database Workbench & NexusDB Versions: 3.0 and up
- Sybase Anywhere - http://www.sybase.com/products/databasemanagement/sqlanywhere - see Database Workbench & Sybase Anywhere Versions: 9, 10 and 11
Database Workbench comes with a multitude of tools to increase productivity and standardization when working
with different databases or multiple developers. Most of the tools can be reached via Tools | <toolname>
or via buttons on the Tools toolbar.
Below is a short description for each tool.
A File Compare tool to compare text files on disk.
A tool to have a quick view a table or view column list - columns can be drag/dropped into any code editor.
A way to record any metadata changes to a script - easy-to-use way to create a list of change-scripts after the first version of a database.
Test Data Generator
A very powerful tool to generate random or unusable random data to fill your database in order to test real-world performance.
The BLOB editor is used to edit the value of BLOB-like columns, it also accepts images, OLE objects and has a HEX-editor.
Multi-level clipboard monitors the Windows clipboard so you can paste items you have copied before the last "copy" action you performed.
To transfer data, or set up the command-line version of the datapump, use this tool. It accepts any ODBC, ADO (OLEDB) or native connection.
The Grant Manager is used for changing and modifying grants of database objects. With the use of Grant Templates, this can also be quickly done for any new users.
Import data from several different formats to populate your database.
Data can be exported to several different formats, for example for reporting, transferring via sneaker mail or stored in development scripts.
Connect to any ADO or ODBC Datasource and browse metadata, run queries and so on. This looks just like a regular database session, except it's read-only for metadata.
A quick way to duplicate an object in the database - simply right-click in the Database Navigator and select this option.
Select, Update, Insert and Delete Stored Procedures can be created very easily by using this tool.
Converts (migrates) database objects to another database. Accepts any ODBC, ADO or native connection as the "source schema", accepts native connections as the "destination schema".
Compares a database to another database or database objects to another set of database objects. Can collect a script with modification statements.
Visual Query Builder
Drag-and-drop interface to create SQL statements.
Copy/Paste tool to go to and from SQL statements to source code files.
Dialog to create links to external programs so you can access them from the Database Workbench Tools menu item.
Stored Code Debugger
Allows you to debug Triggers, Stored Procedures, Stored Functions and Stored Modules (Packages).