|
|
|
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.
DTM Data Comparer, visual tool for two tables data comparison and synchronization.
| Platforms: |
Windows 2000, Windows, Windows 2003, Windows 98, Windows Me, Windows XP |
| Similar: |
|
| Version 1.03.27 Changes: |
New comparison and synchronization mode (database level).
Important interface changes.
Unicode version is now available. |
|
|
|
|
 Related Software
| Title / Version / Description |
Size |
License |
|
| DB Explorer 3.0.0 - Compare two database schemas and/or table data, report differences and sync. |
9.0 KB |
Shareware |
| CompareData 1.4.3.105 - CompareData is a native Windows cross-dbms application that allows you to visually compare and... |
11.2 MB |
Shareware |
| D-Softs Database Comparer 2.2 - D-Softs Database Comparer is a powerful sql database compare tool. It not only can be used to... |
6.7 MB |
Shareware |
| SQL Delta 4.1 - SQL Delta is a great value, fast SQL database compare tool used to analyze, compare and... |
9.2 MB |
Shareware |
| Beyond Compare 3.0.15 - Beyond Compare is a Windows utility that combines directory compare and file compare functions in... |
5.2 MB |
Shareware |
| SwiftCompare lite 1.3 - SwiftCompare lite is a free file compare and folder synchronization tool for Windows. Compare and... |
2.7 MB |
Freeware |
| dbForge Data Compare for SQL Server 1.00 - Data Compare is a tool to compare and synchronize data of Microsoft SQL Server databases. You can... |
5.2 MB |
Shareware |
| FolderMatch 3.4.8 - Quickly and easily compare & synchronize all folders/files with FolderMatch |
4.4 KB |
Shareware |
| SwiftCompare 1.3 - SwiftCompare is one of the most powerful Compare and Merge utilities, both for Files and Folders,... |
2.5 MB |
Shareware |
| VData v2.3 - Compare files and folders on disk, cdrom, floppy, etc.. |
141.0 KB |
Freeware |
DTM Data Comparer User Reviews
|
| |
|
|
