DTM Data Comparer

DTM Data Comparer is a Windows tool by DTM Soft for comparing and synchronising data. It compares the rows of two tables by primary or unique key and highlights missing, equal and different values; six comparison modes are available: table to table, query to table, query to query, text file to table, Excel spreadsheet to table and whole database. Tables can be in the same or in different data sources, for example Oracle and MySQL, and column mapping handles different structures.

The tool generates synchronisation scripts and HTML, Excel and XML reports, and has a command-line mode for scheduled runs. It works through ODBC, OLE DB, IDAPI and the Oracle Call Interface. The latest version, 1.27.03, dates from February 2021; it is a commercial product with a free demo.