DTM Data Comparer

While maintaining a database, the work of DBAs at times becomes hectic when it comes to comparing and synchronizing the data, as it requires viewing, finding, editing, and updating tables, and records by comparing two databases. This takes a lot of your time and efforts, and often ends up in monotony and frustration. But, now you can reduce the burden and perform the task efficiently, for which you simply require trying out DTM Data Comparer 1.03.27. It’s a visual tool that supports comparing and synchronizing tables of databases by updating the content of primary and secondary tables. It also provides you with mapping feature that helps comparing tables with different structure like name and number of fields. Assisting you to figure out changed content the application highlights it with different colors according to changed attribute.

DTM Data Comparer 1.03.27 comes with an extremely simple GUI and sports a remarkable feature-set. To begin with you need to select the ‘Table to Table Mode’ or ‘Database mode’ provided on the main screen. Then you have to choose the primary and secondary data tables/database for comparison and synchronization of data. If ‘Table to Table Mode’ is selected, the selected tables are displayed with main screen parted in two halves, showing each table separately. You’re also provided option for connecting, disconnecting, showing data, or mapping the tables. Further, to commence the process you just need to click on Compare or Synchronize for the program to perform the relevant task. The program displays the results on main screen on both tables highlighting changes or absent, or updated content with different colors. Moreover you can make selection regarding column mapping, unique key specification, and select, save and execute the synchronization script. On the configuration front, you can later settings relating to general, comparisons, and synchronization.

DTM Data Comparer 1.03.27 is capable of performing the data comparing and synchronization task diligently, thus deriving effective results. Assigned with 3 rating points, the software consists of easy-to-use options that facilitate remarkable performance.

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.