DTM Data Comparer 1.03.27
|
|
|
|
Description: 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.
Click here for more information
|
|
Platform: Win98,WinME,WinXP,Windows2000,Windows2003,Windows Media Center Edition 2005,Wind
|
Category: Business :: Databases & Tools
|
|
Type: Demo
|
Cost: $159.00 US
|
Size: 1229 K
|
Released: 2008-10-27 00:00:00
|
|
Download: http://www.sqledit.com/dcmp_demo.exe
|
|
Keywords: compare data, compare tables, compare data rows, data synchronization, db comparision, db sync
|
|
Not rated yet.
|
|
|
Other products by DTM soft:- DTM Data Generator
Intelligent test data generator for database testing: SQL, text, XML output - DTM Data Editor
Database viewer and editor with BLOB import/export options. - DTM Migration Kit
Migration Kit is a powerful yet simple data import, export and migration tool. - DTM Schema Reporter
Create database reports in RTF,HTML, PDF,XML, CHM or text easily with this tool - DTM DB Stress
DTM DB Stress is a utility for database and db-applications stress testing. - DTM ODBC Manager
DTM ODBC Manager is a simple and easy-to-use ODBC Data Sources manager. Freeware - DTM SQL editor
Set of powerful database management tools: ODBC support, schema viewer, builder - DTM Data Modeler
CASE tool for database developers that supports forward and reverse engineering - DTM Data Scrubber
DTM Data Scrubber is a set of intelligent tools for data scrubbing/verification - DTM Query Reporter
Reporting tool for database queries: RTF, HTML, PDF, XML, CHM or text formats - DTM Schema Comparer
DTM Schema Comparer is a visual database schemas comparison/synchronization tool - DTM Schema Inspector
DTM Schema Inspector is a database schema browsing and management tool - DTM Data Generation SDK
DTM Data Generation SDK is a Library and component for test data generation.
Other Business :: Databases & Tools products:
|
|
|