UDB Workbench

3.4.4

Compare database and perfectly synchronize their contents with the help of this advanced piece of software that also bundles an SQL editor and a database query tool

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.

Features a slightly outdated yet quite intuitive UI


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.

Advanced and capable SQL editor plus a useful query tool


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.

Perfectly sync the contents of two databases with the help of this comprehensive app


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.