DBDiff is an ODBC database utility that allows you to compare any two databases accessible from your system. The comparison can be performed at three database levels: structural, indexes, and data. The structural comparison compares the tables of both databases, column names, and column types; the indexes level compares index names and uniqueness as well as the columns in them; and the data level compares the data stored in the tables of the databases. DBDiff creates a user-friendly report that includes the database analysis, structural analysis, indexes analysis, and data analysis.
Version 5.0 allows you to create database snapshots for off-line comparisons, compare data using free form sql selects, conditional data retrievals, executive summary report and much more.