Add new comment

If you have a need to diff tables in schemas and databases you might want to check out Diff Kit at http://www.diffkit.org/.

It looks to be a little bit heavier duty than a standard MINUS/UNION query but it looks like it will talk to Oracle, MySQL, DB2 or any JDBC data source.

From the website:

DiffKit is an application, and a framework, for comparing two tables of data, field-by-field. The tables can come from any of a number of sources, such as an RDBMS or CSV file, and DiffKit is able to mix different kinds of sources in the same diff operation. DiffKit is like the Unix diff utility, but for tables instead of lines of text.

-Dave