Introduction

Previous  Index  Next  How To Use

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.

 

Text (File) Compare

 

A Text and Text File Compare tool to compare text files or pieces of text.

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.

 

ADO/ODBC Explorer

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.

 

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.

 

Special Copy/Paste

 

Copy/Paste tool to go to and from SQL statements to source code files.

SQL/Parameter Insight

 

A code editor tool that helps you to write SQL statements more quickly.

Script Runner

 

An extra tool to execute SQL Scripts from a SQL script file, especially for large files which can clog up the Script editor.

 

To-Do Items

 

Keep track of work you haven't done yet! Create a list of to-do items, for your database on per object.

External Tools

Dialog to create links to external programs so you can access them from the Database Workbench Tools menu item.

 

Allows you to debug Triggers, Stored Procedures, Stored Functions and Stored Modules (Packages).