|
DB Workbench
DB Workbench is a DB2 development and deployment environment. It offers many features,
such as packaging schemas and content of DB2 database, performing DB2 database comparison and
synchronization as well as data comparison and synchronization. SQL editor in this software
supports syntax highlighting, code completion, SQL formatting, script execution; and query tool
has the ability of editing and grouping query results.
Software Information |
System Requirements |
Version: | 3.0 |
- Windows NT 4.0 / 2000 / XP / 2003
- IBM DB2 ODBC driver (Optional if you do not need DB2 connection)
- Adobe Reader or compatible PDF viewer (Optional)
|
File Size: | 1.47 MB |
License: | Free to try, $59.00 to buy |
Screenshot: | View Screenshot |
Rating : | |
Main Features of DB Workbench:
Flexible Connectivity
- Support DB2 UDB 6.X/7.X/8.X
- Support loading schema information from both physical DB2 database and offline file source
Easy Database Object Manipulation
- Support scripting database objects
- Support long script execution. If script was executed from the beginning to the end and error has occurred, the statement where the error occurred will be highlighted
- Schema information will be updated automatically after execution of DDL statements (Configurable)
Powerful SQL Editor
- Support syntax highlighting, code completion and tooltip information
- Support SQL formatting, include letter case conversion, for example, "TitleCase", "camelCase", etc.
- Support track changes mark, split view, full-screen edit, drag-and-drop edit, column selection, multiple levels of undo and redo, Unicode and DOS/UNIX/MAC formatted files
Convenient Query Tool
- Allow editing, grouping, searching and sorting
- Table and record views to see data the way you like it
- 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
- Color-coded side-by-side comparison makes it easy to pinpoint at a glance
- Allow edit and synchronize data comparison results
Generate Synchronization Script for Database Synchronization
- User will be alerted when synchronization script contains any warnings, such as, data truncation, incompatible data type conversion, etc.
- Permit user to review and manually update synchronization script prior to executing it
Other Useful Features
- Convenient to view data content, definition and dependency information of database objects
- Generate script to rebuild invalid database objects, including inoperative views, inoperative triggers and fixing NEXTVAL of identity columns
- Generate script to export data, import data, load data, REORG tables and RUNSTATS tables
|