Database Workbench Pro » Developer.Team

Database Workbench Pro

Database Workbench Pro
Database Workbench Pro | 34 Mb

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
object editors.

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 - - see Database Workbench & InterBase Versions: 4.x, 5.x, 6.x, 7.x, 2007 and 2009.
Firebird, Open Source - - see Database Workbench & Firebird Versions: 1.0, 1.5, 2.x
Microsoft SQL Server - - see Database Workbench & MS SQL Server Versions: 7, 2000, 2005, 2008, MSDE 1, MSDE 2, SQL Express 2005 & 2008
MySQL, Open Source - - see Database Workbench & MySQL Versions: 4, 4.1, 5.x
Oracle Database - - see Database Workbench & Oracle Versions: 8i, 9i, 10g and 11g
NexusDB - - see Database Workbench & NexusDB Versions: 3.0 and up
Sybase Anywhere - - 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 |
or via buttons on the Tools toolbar.

Below is a short description for each tool.
File Compare
A File Compare tool to compare text files on disk.
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.

External Tools
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).


[b] Only for V.I.P
Warning! You are not allowed to view this text.