UDB Workbench

UDB Workbench is a tool for DB2 UDB database comparison and synchronization. It allows you Connect DB2 UDB databases through ODBC or through schema DDL file, and view all the differences Between two connected sources, and execute synchronization script that generated by the tool to synchronize structure of your DB2 UDB databases. In addition, this tool has also come with a powerful SQL editor that features Intellisense-like code completion, parameter hinting, SQL formatting, multiple levels of undo and redo, column mode edit, code folding, etc. Features:Following list describes the main features of UDB Workbench:Flexible Connectivity * Support DB2 UDB 6.X/7.X/8.X/9.X * Support loading schemas through ODBC or through schema DDL file that generated by the tool or that generated by DB2LOOK 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 Schema 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 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 in database explorer will be updated automatically after execution of DDL statements Convenient Query Tool * Allow grouping, filtering, searching, editing 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 * Support results in text