|
UDB Workbench is a development environment for DB2 UDB databases. It includes many features, such as comparing and synchronizing database schemas, packaging schemas and content of DB2 UDB database. SQL editor in UDB Workbench supports syntax highlighting, code completion, SQL formatting, script execution, and query results support filtering, grouping, searching, and more.
Features :
* Support loading schema from both file and database
* Powerful SQL editor that supports code completion, syntax highlighting, SQL formatting, multiple levels of undo and redo, drag-and-drop edit, column selection, column mode edit, etc.
* Convenient query tool that supports filtering and grouping query results; in addition, query results can be exported to Excel spreadsheet or as a set of SQL statements
* Integrated "Diff" tool for database comparison as well as data comparison
* Generate synchronization script for database schema synchronization
* Loaded schema will be updated automatically after execution of DDL statements.
|
