- Audio & Multimedia
- Business
- Communications
- Desktop
- Development
- Education
- Games
- Graphics
- Home & Hobby
- Network & Internet
- Screen Savers
- Security & Privacy
- Servers
- System Utilities
- Web Development
- PickMeApp Pro
- imyPass iPassGo
- RPM Remote Print Manager...
- GHC Timetables generator EN
- ExtraDisks Home
- FTP Client Engine for...
- Professional File Recovery...
- 7Caps
- BriskBard
- DocPad
- VidMasta
- Aml Pages
- BW Meter
- PDFMarkz
- ToolsBaer MSG to HTML...
- ADRC Data Recovery Tools
- avast! Antivirus
- Revo Uninstaller
- Java Runtime Environment
- AVG Anti-Virus Free Edition
- GOM Media Player
- RegSeeker
- IrfanView
- CPU-Z
- Malwarebytes Anti-Malware
- Spybot Search & Destroy
- Skype
- µTorrent
-
2Printer 5.5
Enables you to print any type documents or files in bath mode one after another specifying the paper size and without any...
-
Vivaldi for MacOS 6.6
No ad browser and uses minimum memory, takes very less time to load, some unique features added like notes containing...
-
Win PDF Editor 3.6.3
Editing PDF documents was like nightmare for me but when I am suggested by one of colleagues I tried this and found that...
-
Serial to Ethernet Connector 9.0
It can successfully turn your computer to a terminal server so that any device connected to the com port will be...
-
ShutUp10 1.4.1388
This software will let you take the full control over your windows 10 and decide which program to start automatically or...
-
TeraCopy 3.26
Copies files seamlessly from source to target location, also detects errors while transferring and rectifies it.
-
Ulysses for Windows 2.7.11
Writing application with most of useful features that a standard word processor may offer like markdown, emerging to...
-
InjuredPixels 4.0
It will repair the damaged pixels of the display unit so that it can still be usable for some more days instead of buying...
-
DrvInfo 1.2.0.2016.0
The software will show you the details of a drive as soon as it is inserted into the port whether it is a floppy, flash...
-
Unreal Commander 3.57
Can see the files in windows. You may copy, cut and paste right from there or upload to server directly.
Business / Databases & Tools / DTM Data Comparer 1.25.01
DTM Data Comparer 1.25.01
Advertisement
Advertisement
DTM Data Comparer 1.25.01 Description
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.
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.
Editor rating:
OS: Windows, Windows 7, Win7 x32, WinServer, WinXP, Windows 2000, Windows 2003, Windows Media Center Edition 2005, Windows Vista Business, Windows Vista Enterprise, Windows Vista Home Basic, Windows Vista Home Premium, Windows Vista Starter, Windows Vista Ultimate
System Requirements: ODBC, OLE DB, IDAPI or Oracle Call Interface
Versions History:
Date Released: | Version: | Change Info: |
2015-09-06 | 1.25.01 | $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. |
Tags: Compare Data - Compare Tables - Compare Data Rows - Data Synchronization - Db Comparison - Db Sync
User Reviews of DTM Data Comparer
-
DTM Query Reporter 1.29.02 DTM Query Reporter is a reporting tool for database query. The program creates reports in RTF, XML, HTML, PDF, CHM (Windows HTML Help), Excel or plain text formats and supports all common database interfaces - ODBC, OLE DB, IDAPI or OCI... Download
-
DTM Migration Kit 1.10.05 DTM Migration Kit is a powerful yet simple data import, export and migration tool. It is fully automatic and supports all popular database formats. Simple visual interface lets you set own transformation and flow control rules... Download
-
DTM ODBC Manager 1.04.00 DTM ODBC Manager is a simple and easy-to-use ODBC Data Sources manager. The program allows you to export data source definitions into a file and then restore it on a local or remote system. The program works both with system DSNs and with user DSNs... Download
-
DTM SQL editor 2.03.05 DTM SQL editor is a set of powerful database management tools that allow you to have unified access to different types of databases and to have a set of solutions that makes processing your data easy. Get your free demo version now... Download
-
DTM Schema Reporter 1.24.01 DTM Schema Reporter is a reporting tool for database schema. The program creates reports in RTF, XML, HTML, PDF, CHM (Windows HTML Help), Excel or plain text formats and supports all common database interfaces - ODBC, OLE DB, or Oracle Call Interface.. Download
-
DTM Schema Inspector 1.21.12 DTM Schema Inspector is a database schema browsing and management too that let the user work with database schemas more effectively. The program lets the users work simultaneously with any number of database schemas... Download
-
DTM Schema Comparer 1.07.00 DTM Schema Comparer is a database schemas comparison/synchronization tool. The comparison process supports tables, views, indexes, keys (PK and FK), triggers and stored procedures. Database schemas tree-view makes the process more comfortable... Download
-
DTM DB Stress 1.15.06 DTM DB Stress is a utility for stress testing the server parts of information systems and database applications, as well as DBMSs and servers themselves. The program is useful for any information system developer or any QA department employee... Download
-
DTM Data Scrubber 1.09.02 DTM Data Scrubber is a set of intelligent tools for data verification and scrubbing. Depending on user-defined rules and data properties, the program either creates a report about the actual state of affairs or performs database data correction... Download
-
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... Download