CATEGORIES
Software Development
MySQL , MsSQL & Databases
Current Highlights
Follow us on Facebook
 

DTM Data Comparer 1.23.01

DTM Data Comparer is a visual tool for data comparison and synchronization. The program successively views the contents of both tables basing on the order of ascending of Primary Key (or unique key) values. If the program cannot find two records with the same key value, it places the records to different lines and highlights in yellow. If values of the keys coincide, the program places them to the same lines and highlights equal fields in green and unequal fields in red. When you use mapping, the program leaves columns that don't take part in comparison white.
During synchronization, the program makes the contents of the secondary table equal to the contents of the primary one. In this process records absent in the primary table will be deleted from the secondary one, records that differ will be updated, while records absent in the secondary table will be inserted from the primary one. You can change this behavior using the following options:
1) Delete from secondary - disabling this option will block deleting a record from the secondary table even if there is no such record in the primary table.
2) Insert by primary - disabling this option will block adding records from the primary table even if there are no such records in the secondary table.
"Mapping" feature allows comparing two tables that have different structure (number and name of fields).
During synchronization the program creates a set of insert, update and delete statements for data synchronization. The user can select the necessary statements or forbid the unnecessary ones in a special dialog box.

User's rating:

  • Currently 3.18/5
  • 1
  • 2
  • 3
  • 4
  • 5
Enlarge the screenshot of DTM Data Comparer
[ Enlarge Image ]

Download alternate to DTM Data Comparer solution

Look at the free or trial alternatives and similar apps to DTM Data Comparer software by the tags. It's possible also to find substitutes for the most popular titles in the Software Development category.

| Db Sync | Db Comparison | Data Synchronization | Compare Tables | Compare Data Rows |

History updates (Complete changelogs since the listing on this site)

1.23.01 [11-20-14]

Query to query comparison mode added.
Plural mapping support for Database Mode added.
Diagnostics module improved.

Other versions : 1.22.00 1.21.04 1.21.00 1.20.05 1.17.00 1.16.00 1.15.00 1.14.06 1.14.04 1.14.00 1.13.01 1.10.00 1.09.18 1.09.14 1.09.11 1.09.08 1.08.01 1.07.08 1.07.05 1.07.00 1.06.00 1.05.00 1.03.33 1.03.28 1.03.27 1.03.23 1.03.21 1.03.17 1.03.03 1.02.10

v1.22.00 [03-14-14]

New data grid customization options added.
Key mapping diagnostics enhanced.
New Excel report options: color support, etc.

v1.21.04 [11-30-13]

Better report summary support for complex mapping.
Environment clean up improvement for large scale tables comparison.
Diagnostics extended for constant-to-column mapping.

v1.21.00 [10-29-13]

Better report summary support for complex mapping.
Environment clean up improvement for large scale tables comparison.
Diagnostics extended for constant-to-column mapping.

v1.20.05 [10-15-13]

Memory manager optimized for large scale tables.
Optional "Table of content" added for HTML comparison reports.
New CSS-customization options for HTMl report.
Direct integration with DTM Schema Comparer implemented.

v1.17.00 [09-03-13]

Memory manager optimized for large scale tables.
Optional "Table of content" added for HTML comparison reports.
New CSS-customization options for HTMl report.
Direct integration with DTM Schema Comparer implemented.

v1.16.00 [06-25-13]

New comparison option: use conversion expression.
Better Windows 8 support.
Major connectivity module update.

v1.15.00 [03-12-13]

New comparison modes: query to table, file to table and Excel to table.
New settings, command line switches and options.
Major user interface update.
Better support for project backups.

v1.14.06 [11-27-12]

"Ignore quotation" comparison option.
New table list context menu.
Data type compatibility check was added.
Import and Export settings feature.
Added "create rollback script" feature.
Project properties window major update, GUI fixes.
New Excel ready comparison report.

v1.14.04 [11-14-12]

"Ignore quotation" comparison option.
New table list context menu.
Data type compatibility check was added.
Import and Export settings feature.
Added "create rollback script" feature.
Project properties window major update, GUI fixes.
New Excel ready comparison report.

v1.14.00 [09-03-12]

"Ignore quotation" comparison option.
New table list context menu.
Data type compatibility check was added.
Import and Export settings feature.
Added "create rollback script" feature.
Project properties window major update, GUI fixes.
New Excel ready comparison report.

v1.13.01 [07-16-12]

"Ignore quotation" comparison option.
New table list context menu.
Data type compatibility check was added.
Import and Export settings feature.

v1.10.00 [05-30-12]

"Ignore quotation" comparison option.
New table list context menu.
Data type compatibility check was added.
Import and Export settings feature.

v1.09.18 [02-09-12]

Better support for collations (SQL Server, Oracle, MySQL, PostgreSQL 9).
Table list refresh feature.
GUID conversion feature.
Better support for national strings comparison.

v1.09.14 [12-11-11]

Better support for collations (SQL Server, Oracle, MySQL, PostgreSQL 9).
Table list refresh feature.
GUID conversion feature.
Better support for national strings comparison.

v1.09.11 [11-24-11]

Better support for collations (SQL Server, Oracle, MySQL, PostgreSQL 9).
Table list refresh feature.
GUID conversion feature.
Better support for national strings comparison.

v1.09.08 [09-30-11]

Better support for collations (SQL Server, Oracle, MySQL, PostgreSQL 9).
Table list refresh feature.
GUID conversion feature.
Better support for national strings comparison.

v1.08.01 [07-18-11]

Value conversion feature added.
GUI performance enhancements.
Better support for SQL Server 2008 data types.

v1.07.08 [02-01-11]

Important GUI changes (toolbars, status bar, layout)
Memory usage optimizations
New comparison report options and features

v1.07.05 [01-14-11]

Important GUI changes (toolbars, status bar, layout)
Memory usage optimizations
New comparison report options and features

v1.07.00 [12-12-10]

Important GUI changes (toolbars, status bar, layout)
Memory usage optimizations
New comparison report options and features

v1.06.00 [12-02-10]

Face-to-face row comparison form.
Added comparison status indicator.
$DATE$ and $TIME$ macros for report and script file name.
New comparison settings.

v1.05.00 [11-21-10]

Complete BLOB comparison support.
Important optimizations for large scale databases.
New options and redesigned settings window.
Added row comparison status icons.

v1.03.33 [02-02-10]

New comparison and synchronization mode (database level).
Important interface changes.
Unicode version is now available.

v1.03.28 [04-12-09]

New comparison and synchronization mode (database level).
Important interface changes.
Unicode version is now available.

v1.03.27 [10-25-08]

New comparison and synchronization mode (database level).
Important interface changes.
Unicode version is now available.

v1.03.23 [02-29-08]

New comparison and synchronization mode (database level).
Important interface changes.
Unicode version is now available.

v1.03.21 [02-04-08]

New comparison and synchronization mode (database level).
Important interface changes.

v1.03.17 [10-07-07]

New comparison and synchronization mode (database level).
Important interface changes.

v1.03.03 [08-03-07]

New comparison and synchronization mode (database level).
Important interface changes.

v1.02.10 [02-07-07]

New product options and settings
Constant mapping feature has been implemented

Average review rating :

Useful independent reviews and opinions of the users

Review DTM Data ComparerWrite a review « Be the first to post a review for DTM Data Comparer download!

Predicted future versions and notices:

The doDownload.com constantly monitors the update of all programs, including information from the DTM Data Comparer 1.23.2 changelog file, however sometimes it can happen that data are not complete or are outdated.We assume that author continue's to develop 1.24.0 version with further advanced features, and soon you will be informed. Equally important 2.0.0 upgrades of the program we will continue to monitor. Full DTM Data Comparer description has been compared with the overall software database and our algorithm has found the following applications (are showed below).

Download 1.38MB DTM Data Comparer

Download Direct

(1.38MB, Extension: EXE)