an ODBC database utility that performs a comparison between two databases.
EditByBSEditor: DBDiff is an ODBC database utility that performs a comparison Between two databases.
Any database that supports ODBC access can be used. The databases DO NOT have to be of the same type, they don鈥檛 even need to be on the same machine, as long as they are both accessible from the machine running DBDiff.
DBDiff uses a carefully planned and designed Algorithm for performing the quickest, most accurate comparison between the databases; this algorithm allows for multiple levels of comparison to be performed on the databases.
Ver. 5.0 now allows you to compare data by using free form sql select Statements, you can also Create database snapshots to perform off-line comparisons or track historical changes, and many more new features.

Table Structure Comparison - This level will perform a comparison between all tables of the databases. It will find the tables that are common and perform comparisons between their respective columns to find and report the differences (i.e. which columns are common, which are not and what are their differences). DBDiff can go as deep as the length of a column or can be set to ignore the length as well as ignore some columns that it is already known to the user to be different.

Index Comparison - This level will perform a comparison between all the indexes found on all the tables that are common to the database. Index Comparison will retrieve all the indexes that apply to a particular table and compare them with the corresponding ones on the second database (i.e. DBDiff will report all differences regarding indexes, their types (unique or not unique) as well as each of the columns that the index applies to). you can free download DBDiff 5.0 now.