DTM Data Comparer 1.15.00

DTM Data Comparer by DTM soft is a visual tool for data comparison and sync. 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.
The most important trend of the modern corporate computing is database growing. The user or DBA who need to compare or synchronize large tables is obligated to waste a lot of time. The new release of DTM Data Comparer 1.15.00 is modified to operate on tables with 15-20 million and more rows without speed degradation.
DTM soft CTO said: " We completely redesign our memory management and CPU usage model. The comparer became up to 8-10 faster for tables greater than 10M rows" .
Another DTM Data Comparer [dtmdatacomparer1.15.00.exe] addition is better flexibility for multivendor environment. New options and settings allows the user to tune comparison process more minutely. For example, prologue and epilogue SQL scripts allow the user to prepare SQL environment to achieve better performance of the synchronization process.
DTM Data Comparer - 1.31MB now supports comparison report customization and localization. The HTML report can be tuned by CSS tables. The program can use custom external file with strings that can be translated to any language.
DTM Data Comparer 1.15.00 is distributed electronically over the Internet; free demo version is available to download at www. sqledit. com/dcmp for evaluation.
DTM soft is ISV specializing in developing data processing tools since 1998. DTM Data Comparer is an important part of the company' s product line that also includes titles like DTM Schema Comparer, DTM Data Generator, DTM DB Stress and DTM Migration Kit. More information about the software products and services is available at www. sqledit.