DTM Data Comparer is a highly visual and intuitive utility that focuses on data comparison and synchronization. The program continuously displays the contents of two database tables, according to the ascending order of the first key (or the unique key). The basic operation is as follows:
If DTM Data Comparer cannot find two records with equal values, it places them on different lines and highlights them in yellow. If you find two matching key values, place them on the same line and highlight the same fields in green, and the different fields in red. Columns that do not participate in the comparison process are left blank.
During the synchronization process, Data Comparer matches the contents of the secondary table with those of the primary table. This means that records that are not present are deleted, and those that are different are updated. This one just described is the default program behavior, but we can alter it if we change the settings.
During the synchronization process, DTM Data Comparer creates a set of insert, update and delete data statements. The user can select the sentences he needs, and discard the others.
You can free download DTM Data Comparer 32, 64 bit and safe install the latest trial or new full version for Windows 10 from the official site.