Introduction
Previous  Top  Next

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.

Describe Companion
A tool to have a quick view a table or view column list - columns can be drag/dropped into any code editor.
Session Recorder
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.
BLOB Editor
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.
Data Pump
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.
Grant Manager
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.
Data Import
Import data from several different formats to populate your database.
Data Export
Data can be exported to several different formats, for example for reporting, transferring via sneaker mail or stored in development scripts.
Duplicate Object
A quick way to duplicate an object in the database - simply right-click in the Database Navigator and select this option.
SUID Procedures
Select, Update, Insert and Delete Stored Procedures can be created very easily by using this tool.
Schema Migrator
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".
Schema Compare
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.
External Tools
Dialog to create links to external programs so you can access them from the Database Workbench Tools menu item.