UDB Workbench

UDB Workbench is an advanced and efficient piece of software that allows you to compare and synchronize two databases. In just a few words, this utility connects to DB2 UDB databases and allows you to visualize the differences between them, and swiftly executes scripts with the purpose of synchronizing their structures.

Right off the bat, you should also know that this tool comes with support for loading schema through ODBC or DDL and that it is perfectly capable of working with DB2 UDB 6.X all the way up to 9.X.

Regardless of your computer experience, you should be able to deploy this utility on your computer's system without problems, thanks to its streamlined installer. Once launched, you are met by a well-organized, tabbed interface that is a bit on the old side.

Nevertheless, you should be able to find your way around this app quite rapidly. You can start off by loading your databases. In addition to the side-by-side comparison panels for the source and the target database, you should also get your first glimpse at the utility's advanced SQL editor.

Capable of handling complex SQL syntax and boasting features like IntelliSense code completion, parameter hinting and support for line revision marks, split view, drag and drop edit, code folding, wildcard search and replace, it will surely come in handy.

There's also a capable query tool that allows you to group, filter, edit, sort and search for table and records. Please note that the results can be effortlessly exported to Excel spreadsheet format, for indexing purposes.

Taking everything into consideration, UDB Workbench is a relatively lightweight and attractive app that allows you to compare, differentiate and perfectly sync two databases, as well as modify them with the help of available the SQL query and editing tools.