IBM Cloudscape Workbench

最新推荐文章于 2025-12-04 15:25:15 发布

最新推荐文章于 2025-12-04 15:25:15 发布 · 120 阅读

文章标签：

#数据库

本文介绍了Cloudscape Workbench工具，它可同时连接Derby和DB2数据库，能以分层视图浏览数据库模式，支持用SQL模板创建新对象、编辑DDL修改现有对象等操作，还能生成DDL脚本、迁移Derby数据库到DB2等，且支持连接多种版本数据库。

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