DTM Data Comparer 1.25.01
DTM Data Comparer-visual tool for data comparison and synchronization with automation facility. HTML or Excel reports, multivendor environment support with unified interfaces: ODBC, OLE DB, etc. Flexible and customizable. Mapping and data conversion.
Download
1.42 MB · dcmp_d.exe
1.1Kdownloads
0this week
$159Demo
0reviews
Screenshots
About DTM Data Comparer
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.
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.
| Requirements | ODBC, OLE DB, IDAPI or Oracle Call Interface |
|---|---|
| Release info | Major Update on Sep 06, 2015 |
| Release notes | $TableLeft$ and $TableRight$ macros added for report file name. $DATE$ and $TIME$ macro format can be changed in the settings. SQLite and SQLAnywhere support improved. |
| Related tags | compare data compare tables compare data rows data synchronization db comparison |
Reviews
No reviews yet. Be the first to review DTM Data Comparer.
Used DTM Data Comparer? Tell other visitors what you thought.
Log in to write a reviewOther products by this publisher
-
DTM Data Editor 1.04.07
DTM Data Editor is a database viewer and editor with BLOB support for professionals who are tired of wasting their time on mundane tasks. The program uses form-based interface and works with any ODBC data source. Automatic SQL statements generation.
-
DTM Data Generation SDK 1.57.00
DTM Data Generation SDK is a Library and component for test data generation that allows the programmer, webmaster or advanced user to add test data generation features to application, script or website. Easy to use with C/C++,C#,ASP, scripts support.
-
DTM Data Generator 2.00.11
DTM Data Generator is a tool that generates data for database testing. It creates test data rows, database tables and schema objects (views, triggers). The tool resolves foreign keys and order of tables automatically. SQL, text, JSON and XML output.
-
DTM Data Generator for Excel 2.01.01
DTM Data Generator for Excel is a tool that generates test Excel spreadsheets. The tool provides dozens built-in data generators: address, phone, e-mail, name, etc. The value library makes data more realistic. Custom generators are also available.
-
DTM Data Modeler 1.13.05
DTM Data Modeler is a CASE tool for database developers that supports both forward and reverse engineering. It is an easy-to-use tool allowing you to work both with logical and physical data models in the form of an entity-relationship diagram.
Most viewed Windows Database Tools
-
1
Clarion viewer 2.52
This tool allow to read/open the Clarion tables on any computer.
An application don't use any external libraries (no BDE, no ODBC, no ADO etc)
You may see the full Clarion system information, table structure and data in grid.
-
2
EMS SQL Manager for SQL Server 3.9
EMS SQL Manager for SQL Server is a high performance tool for Microsoft SQL Server database development and administration. SQL Manager works with any MS SQL Server versions from 7 to the newest one and supports the latest SQL Server features.
-
3
DBF Viewer 2000 6.55
With DBF Viewer 2000 you can view, edit, sort, create, print and export dbf files to a variety of formats (DBF, TXT, CSV, Excel, HTML, XML, PRG, SQL, RTF) without using any packages. Unlike other similar programs, DBF Viewer 2000 is fast!
- 4 DataNumen Access Repair 2.2 DataNumen Access Repair is a powerful Access recovery tool. It uses advanced technologies to scan the corrupt Microsoft Access databases and recover your data in them as much as possible, so to minimize the loss in file corruption.
- 5 PHP DataGrid AJAX Enabled Web Control 8.2.7 PHP DataGrid (AJAX Enabled) script is a simple, innovative and powerful tool for generating data-bound grid control. It was specially designed for web developers.
-
6
Universal SQL Editor 1.9.2.2
Intellisense enabled SQL editor for Oracle, DB2, SQL Server, Sybase, etc., with SQL formatter/beauifier, query result supports grouping, filtering, searching, and can also be exported to Excel spreadsheet or as a set of SQL statements.
-
7
Excel-Mysql converter 3.0
convert MySql to Excel spreadsheets or convert any Microsoft Excel spreadsheets into MySQL utilizing easy to use Wizard style interface, Just follow the simple screens and let the wizard automatically do all the work ..
- 8 xBaseView Database Explorer 11.0 Browse database Explorer style and other typical operations. Data export/import. Oracle, SQLAnywhere, PostgreSQL, Cache, SQL Server, Interbase, Firebird, Access, VFP, FoxPro, dBase, Clipper, Paradox, MySQL, SQLite, Borland CDS, XML, Excel, CSV, TAB.
-
9
Data Loader 4.8
A simple yet powerful tool to Export, Import, Migrate and Convert data between different databases and delimited flat text CSV files. Supports Saving & Scheduling of Sessions and Repository.
-
10
Altova MapForce Enterprise Edition 2017sp2
Altova MapForce 2017 Enterprise Edition is a graphical data mapping, integration, and ETL tool. Map any combination of XML, database, EDI, XBRL, flat file, Excel, JSON, and Web service, then convert data instantly or automate recurrent conversions.
Most downloaded Windows Database Tools
-
1
Clarion viewer 2.52
This tool allow to read/open the Clarion tables on any computer.
An application don't use any external libraries (no BDE, no ODBC, no ADO etc)
You may see the full Clarion system information, table structure and data in grid.
-
2
DBF Viewer 2000 6.55
With DBF Viewer 2000 you can view, edit, sort, create, print and export dbf files to a variety of formats (DBF, TXT, CSV, Excel, HTML, XML, PRG, SQL, RTF) without using any packages. Unlike other similar programs, DBF Viewer 2000 is fast!
- 3 xBaseView Database Explorer 11.0 Browse database Explorer style and other typical operations. Data export/import. Oracle, SQLAnywhere, PostgreSQL, Cache, SQL Server, Interbase, Firebird, Access, VFP, FoxPro, dBase, Clipper, Paradox, MySQL, SQLite, Borland CDS, XML, Excel, CSV, TAB.
-
4
Excel-Mysql converter 3.0
convert MySql to Excel spreadsheets or convert any Microsoft Excel spreadsheets into MySQL utilizing easy to use Wizard style interface, Just follow the simple screens and let the wizard automatically do all the work ..
-
5
Data Loader 4.8
A simple yet powerful tool to Export, Import, Migrate and Convert data between different databases and delimited flat text CSV files. Supports Saving & Scheduling of Sessions and Repository.
-
6
Universal SQL Editor 1.9.2.2
Intellisense enabled SQL editor for Oracle, DB2, SQL Server, Sybase, etc., with SQL formatter/beauifier, query result supports grouping, filtering, searching, and can also be exported to Excel spreadsheet or as a set of SQL statements.
- 7 PHP DataGrid AJAX Enabled Web Control 8.2.7 PHP DataGrid (AJAX Enabled) script is a simple, innovative and powerful tool for generating data-bound grid control. It was specially designed for web developers.
-
8
dbForge Studio for Oracle 4.5
dbForge Studio for Oracle is a powerful integrated development environment (IDE) which helps Oracle SQL developers to increase PL/SQL coding speed, provides versatile data editing tools for managing in-database and external data.
-
9
DBScribe for SQL Server 1.4
Leadum DBScribe is a sql documentation tool for SQL Server. It supports a rich set of documentation styles, output formats (HTML, CHM, MS Word Document), wizard and command line interfaces, complete database schema documenting.
- 10 DataNumen Access Repair 2.2 DataNumen Access Repair is a powerful Access recovery tool. It uses advanced technologies to scan the corrupt Microsoft Access databases and recover your data in them as much as possible, so to minimize the loss in file corruption.