DTM Data Comparer allows users to compare and synchronize data easily. It visually compares tables based on unique key values and generates synchronization scripts for differences.
DTM Data Comparer is a user-friendly software program designed for data comparison and synchronization. The software offers a visual tool that displays the contents of two tables side by side, allowing the user to compare and synchronize the data from the corresponding fields.
The program has a unique algorithm that views the contents of both tables based on the order of ascending Primary Key values. Records with the same key value are placed on the same line and highlighted in green for equal fields and red for unequal fields. If the program cannot find two records with the same key value, it places the records on different lines and highlights them in yellow.
DTM Data Comparer features a mapping function which allows for the comparison of two tables with different structures or names of fields. When synchronizing data, the software ensures that the contents of the secondary table match that of the primary one. Records absent in the primary table are deleted from the secondary one, while records that differ are updated. Records absent in the secondary table are inserted from the primary one.
The program provides two options to control this behavior. Firstly, disabling the 'delete from secondary' option prevents the software from deleting a record from the secondary table even if there is no such record in the primary table. Secondly, disabling the 'insert by primary' option blocks adding records from the primary table, even if there are no such records in the secondary table.
DTM Data Comparer generates a set of insert, update, and delete statements for synchronizing data during the process. A special dialog box allows users to select the necessary statements or forbid unnecessary ones. Overall, the software is an excellent tool for synchronizing and comparing data between different tables.
The program has a unique algorithm that views the contents of both tables based on the order of ascending Primary Key values. Records with the same key value are placed on the same line and highlighted in green for equal fields and red for unequal fields. If the program cannot find two records with the same key value, it places the records on different lines and highlights them in yellow.
DTM Data Comparer features a mapping function which allows for the comparison of two tables with different structures or names of fields. When synchronizing data, the software ensures that the contents of the secondary table match that of the primary one. Records absent in the primary table are deleted from the secondary one, while records that differ are updated. Records absent in the secondary table are inserted from the primary one.
The program provides two options to control this behavior. Firstly, disabling the 'delete from secondary' option prevents the software from deleting a record from the secondary table even if there is no such record in the primary table. Secondly, disabling the 'insert by primary' option blocks adding records from the primary table, even if there are no such records in the secondary table.
DTM Data Comparer generates a set of insert, update, and delete statements for synchronizing data during the process. A special dialog box allows users to select the necessary statements or forbid unnecessary ones. Overall, the software is an excellent tool for synchronizing and comparing data between different tables.
What's New
Version 1.08.01:
Value conversion feature added.
GUI performance enhancements.
Better support for SQL Server 2008 data types.