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. It is like the Unix diff utility, but for tables instead of lines of text. Diffs can be reported at both the row and field level, and the user can configure what to compare, how to compare it, what to ignore). DiffKit is highly customizable with respect to the sources of tabular data, the details of the comparison, and the characteristics of the output (diff report).
|Tags||diff SQL csv|
|Operating Systems||Java 1.5|
Release Notes: DiffKit can now diff Excel spreadsheets.
Release Notes: You can add your own jars to the DiffKit application (with no source needed) by copying them into the "dropin" directory. Minor data type bugs with HyperSQL were fixed.
Release Notes: A bug in which connections were not working for HyperSQL databases in Server mode was fixed.
Release Notes: SqlPatchSink was not generating proper DML statements when a String value contains a single quote. MagicPlan was not working for tables that have all columns being part of the primary key. These issues have been fixed.
Release Notes: DiffKit can now generate DB patch files.