IBM Cloudscape Workbench

IBM Cloudscape Workbench

http://www-128.ibm.com/developerworks/db2/downloads/csworkbench/

Functionality

With the Cloudscape Workbench, you can:

    * Connect simultaneously to Derby and DB2 databases.
    * Browse the database schemas in a hierarchical view.
    * Create new database objects using SQL templates.
    * Alter existing objects by editing their DDL (Data Definition Language).
    * Drop objects.
    * Generate DDL scripts for all or part of a database.
    * Edit SQL scripts with a dedicated editor featuring syntax highlighting and content assist.
    * Extract and Load data from tables to local files.
    * View and edit the data stored in tables.
    * Migrate Derby databases to DB2.

The Cloudscape Workbench allows you to connect to the following databases:

    * Derby 10.1, using the embedded driver, the Derby Client, or the DB2 Universal driver
    * Derby 10.0, using the embedded driver or the DB2 Universal driver
    * DB2 UDB 8.1 and 8.2 for Linux®, UNIX®, and Windows®, using the DB2 Universal driver