DTM Data Comparer v1.25.01
by DTM soft
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.
$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.
"Ignore quotation" comparison option.
New table list context menu.
Data type compatibility check was added.
Import and Export settings feature.
Added "create rollback script" feature.
Project properties window major update, GUI fixes.
New Excel ready comparison report.
Better support for collations (SQL Server, Oracle, MySQL, PostgreSQL 9).
Table list refresh feature.
GUID conversion feature.
Better support for national strings comparison.
Important GUI changes (toolbars, status bar, layout)
Memory usage optimizations
New comparison report options and features
Released:September 6, 2015
Platforms:Windows 2000, Windows XP, Windows 2003, Windows Vista, Win7 x32,WinServer,Windows Vista Ultimate,Windows Media Center Edition 2005,Windows Vista Starter,Windows Vista Home Basic,Windows Vista Home Premium,Windows Vista Business,Windows Vista Enterprise
Requrements:ODBC, OLE DB, IDAPI or Oracle Call Interface
Install:Install and Uninstall
Compare 2 separate blocks of Excel cells and find differences between them. Comparison results explain which cells were changed and which rows have been added or deleted. There is a feature for finding matches between two blocks of cells. Also, there
Find content differences between two tables in a MS SQL Server database. Find added and deleted records. Find changed data within the tables.
Find content differences between two tables in a MySQL database. Find added and deleted records. Find changed data within the tables.
Find content differences between two tables in a MS Access database. Furthermore, you have the option to create a new table based on the differences of your choosing. Thus, you can selectively merge two tables together.
dbForge Data Compare for Oracle is a powerful, fast and easy tool for comparing and synchronizing Oracle databases. It helps you quickly compare data in tables, view the differences at a glance and execute an automatically generated script to eliminate
dbForge Data Compare for SQL Server is a powerful, fast and easy to use SQL compare tool able to complete any data comparison and synchronization tasks and provide the best professional tricks to easy your database management. You can quickly analyze
Dmailer Sync - Data Synchronization Software
You travel frequently and/or depend on a borrowed PC during your daily routine?
Dmailer Sync Software meets your data mobility needs.
Once Dmailer Sync Software is loaded on your mobile
Universal database conversion program is most appropriate and cost effective solution to convert or transfer entire or selected database records including tables, rows, columns, structure, views, fields, primary, unique key constraints, fields from MS
DTM Schema Comparer is a handy and reliable application designed to perform database schemas comparison and sync.
DTM Schema Comparer will compare tables and table elements such as colum properties, triggers, stored procedures and keys. The
Transfer data (tables) from one FoxPro database to another quickly. Simply provide the file location for both databases to connect. No SQL knowledge is required.
Most popular Databases & Tools
Import Export Tally (6.3, 7.2, 8.1, 9.0) Data to your software without any hassel within few minuts.
If you are using Tally then you must need this utility. No need to re-enter your data into Tally. Completely avoid re-ernering work.
Universal SQL Editor is a lightweight Intellisense-enabled database query tool.
It allows you connect Oracle, DB2, SQL Server, Sybase and any ODBC compliant database, and edit complex SQL with Intellisense-like autocompletion, highlight references
CRD (Crystal Reports Distributor) is a Crystal Reports Scheduler that saves time & money by making it easy to automate Crystal reports. Just define single or packages of Crystal Reports, schedule, run them automatically and send the reports to print,
This Easy to use tool allows user to connect to any database and browse or modify data ,run sql scripts, export and print data. And the most important thing it is Freeware.
Sai Soft Hotel Catering Software is a dynamic hotel and motel software which improve guest service while achieving profitability. This software is ideal solution for all kind of property. Main features include: Quick check-in/out, hotel status from the
Aglowsoft SQL Query Tools includes three database tools. They are Aglowsoft Schema Tool, Aglowsoft Designer, and Aglowsoft Browser. The tools are designed to allow building of SQL queries with basic knowledge of SQL using user-friendly interface. Result
MDE Unlocker is a program by EverythingAccess.com to unlock your Access MDE files so that you can make changes such as altering/amending forms and reports. This is a new technique that no other company has yet managed to achieve!
Unlike other utilities
Fingerprint authentication, network support, more detailed reports, QuickBooks® integration, door access control, plus quick and easy setup; make Biometric Employee Time Clock 2.0 the most powerful time and attendance solution to stop time theft.
InterbaseRecovery is a comprehensive data recovery software for damaged Interbase and Firebird databases. In case of sudden database crash, it is it essential to recover data as fast and fully as possible. InterbaseRecovery meets these requirements ideally
Bilingual Dictionaries Dutch, Spanish, French, German, English, Portuguese, Italian, Swedish, SQL, MS-Excel, MS-Access. For Companies with own applications: Dictionaries, Thesauruses and Verb Conjugations for English, French, Spanish, German, Portuguese
DTM Data Comparer Author's Software
Database developers and administrators know the testing routine very well. One of the most unpopular tasks is creating data sets for testing new databases. On average, it takes several hours to several days of dull work, since each data set has to be
DTM DB Stress is a utility for stress and load testing the server parts of information systems and database applications, as well as DBMSs and servers themselves. Also it is suitable for database benchmarking and performance tuning. This tool allows you
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 developers kit with C/C++, C#, ASP,
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 (IDEF1X notation)
DTM Query Reporter, as the name implies, is a reporting tool for database query. This utility helps technical writers and database administrators create a report of any complexity level within seconds. And importantly, it supports all common database
Editing data entries one by one manually is akin taking the stairs to the top of the skyscraper. DTM Data Editor is the "elevator" that makes the mundane task of low level data manipulation a snap. Among program's nifty features are form-based interface
DTM Test XML Generator creates a set of XML documents with same structure for testing purposes. It has a few built-in data generators: integers, strings, date and time values, address, e-mail, IP-address, URL, zip code, etc. Also, it has value library
DTM Data Generator for Excel is a tool that generates test Excel spreadsheets. It is must have tool for any developer who deals with Excel data files. The data generator provides dozens built-in data generators: address, phone, e-mail, first and last
DTM Data Generator for JSON is a tool that generates test JSON files in a bulk manner. It is must have tool for any developer who deals with JSON data files. The data generator provides dozens built-in data generators: address, phone, e-mail, first and
DTM File Factory is a template based test file generator. The software supports a lot of data sources: databases, Excel spreadsheets, text files, XML documents, web files, regular expressions, etc.
Value library with most useful data: countries, cities