Error message

Deprecated function: The each() function is deprecated. This message will be suppressed on further calls in _menu_load_objects() (line 579 of /home/aufr/public_html/includes/menu.inc).

DTM Data Comparer

Data Comparison and Synchronization Software

Important Links

Manufacturer :

DTM soft

Search more about this tool in QATestingTools archive

Visit Website

Download HERE

Tool Support link HERE

StackOverflow Search Questions

Tool Information

Introduction

Tool Summary

DTM Data Comparer is a visual tool for data comparison and synchronization. The program successively views the rows of two tables basing on the order of ascending of primary or unique key values. If the tool cannot find two records with the same key value, it places the records to different lines and highlights in yellow. For equal key values the program places them to the same line and highlights equal fields in green and unequal fields in red. When the user define mapping the program leaves columns that don't take part in comparison white.

Last Release Year ['Active'=Current]:

Active

Since (maturity):

2005

DTM Data Comparer
	Tool Scope	Testing Utility
	Application Rights	Commercial, Demo, User license
	Since	2005
	Company	DTM soft
	Support	Tool Support link HERE
	Download	Download HERE

Features

There is five comparison modes: table to table, query to table, text file to table, Excel spreadsheet to table and database.
Compares tables in the same or in the different data sources.
Visual comparison process and comparison HTML-report
Excel comparison results to analyze differences by external tools.
Mapping feature helps to compare tables with different data and key structures.
Database independent. Allows to compare a table in Oracle database with table in MySQL as well as Interbase table with table in DB2 database. DTM Data Comparer supports all common database interfaces: ODBC, IDAPI, OLE DB and Oracle Call Interface.
A Win32 application
Supports Windows 2000, XP, Vista, Windows 7, Windows 8(desktop), Windows Server 2003, 2008, 2012. x64 version of the tool is available for registered users.

Advantages -

Easy to use interface
Custom key support feature - to compare desktop files without Primary Keys.
Compares and synchronizes millions of rows
Multivendor environment support: ODBC, OLE DB, IDAPI and Oracle Call Interface.
Customizable HTML data comparison report.
ANSI and Unicode versions available.
Console (command line) mode
Integrates with Windows Task Schedule

DTM data comparer 150.png

Getting Started

How to compare data with DTM Data Comparer software?

DTM Data Comparer is a software that developed to help user to compare data easy and fast. The key product feature is database comparison results visualization. There are only three simple steps to compare data with this tool:

Connect to database for primary and secondary data sources. You can operate with single database as well as with two different databases (like DB2 and Informix).
Select two tables to be compared.
Run the compare data process.

Also, a few optional settings make compare data process more flexible. They are:

WHERE clause allows users to limit data rows to be compared
Mapping feature is an easy way to compare data with different structure.
Data compare process can produce HTML report (sample comparison report). The user can specify project level file name or product level report file.
Custom unique key specification to compare data from tables without primary key
NULL value comparison option. The user can consider all NULL values different or equal

Can DTM Data Comparer compare data in my databases?

The comparison tool must be executed at Windows system even your database is located at Linux, Solaris or even mainframe system.
You must have ODBC driver or OLE DB provider to connect your database. For Oracle the program can use native Oracle Call Interface (OCI) instead.
Both tables to be compared must have unique column or set of columns. The primary key will be recognized automatically. Otherwise you should select unique key manually.

Video

Videos

Presentation

Presentations

Click here to download the PDF file.

Files & Media

Media & Files

User Guide:

View User Guide

External Articles:

DTM Database Tools Support Forums

Article DTM Data Comparer

DTM Data Comparer Online Documentation

Price Information

DISCLAIMER

In any case of miss-information between QATestingTools and the manufacturer call-center or website, the manufacturer price is the one you should take in consideration,the QATestingTools is NOT responsible for any miss-understanding or miss-information since we are NOT always informed on prices programs updates. In all cases please get more details from manufacturer.

Contact Manufacturer for exact prices information

KickOff Pricing:

2016: DTM Data Comparer - US $159

2016: DTM Data Comparer - US $949/ 10 licenses

Specifications

Tool Specifications

Application Rights:

Commercial

Demo

User license

Tool Scope:

Testing Methods:

Tool Objectives:

Data Warehouse Testing

Databases Required:

Microsoft® SQL Server

Oracle DB

Operating Systems:

Windows Server

Windows Server 2003

Windows Server 2008

Windows

Windows Vista

Windows XP

Windows 7

Hardware Requirements:

Screen: 800x600

Hard Disk

Hard Disk: 100MB

Supported Technologies:

Database

IBM DB2

MySQL

Oracle

Win32

Data Generator Ability:

Data Manipulation ability

Data Visual Review

Automation Tool Features:

Compare Data between differ formats

User Interface Available:

Command Line

Results Presentation:

Built-in Graphs

Configurable

HTML Reports

Share Reports

Summary Results Display

Reporting Formats:

HTML

MSExcel

TXT

Training:

Blog

Documentation OnSite

FAQ

Forums

Live Chat

OnLine Help

Data Sourcing:

Excel Import/Export

Was This Helpful?:

MANUFACTURERS Wallboard

View MANUFACTURERS Wallboard

Testing tool manufacturers world-wide list
10Levels	ABID CONSULTING	AccelQ	Accord Software	ActiMind	AdaCore
AdaLog	AgileLoad	AgileWay	Agitar	Algorismi	ALL4TEC
Andreas Kleffel	Android	Apache	Apica	Apollo Systems	AppAssist.mobi
Applitools	AppPerfect	Appsee	ApTest	Assertible	Assure
Atlassian	AutoIt Consulti ..	Automation Anyw ..	Automation Cons ..	Axosoft	Aztaz Software
Backtrace I/O	Badboy	BlazeMeter	Borvid	BrowserStack	BSQUARE
BStriker Intern ..	CA Technologies	Canonical	Canoo Engineeri ..	Catch Software	CelestialTeapot
Chris Mallett	Cleanscape	ClicTest	CloudQA	Codeborne	CodeCentrix
CodePlex projec ..	Codoid	Cogitek	Compuware	Configure IT	Conflair
ConSol	Core Services	Coronys Ltd	Countersoft	CresTech Softwa ..	CrossBrowserTes ..
Crosscheck Netw ..	Crowdsourced Te ..	Cucumber Ltd	Cyara	Cygnet Infotech	DareBoost
Databene	Datamatics Glob ..	DevExpress	DTM soft	Dynatrace LLC	EasyQA
Eclipse	EkaTechserv	Elvior	Emmanuel Jorge	Empirix	EPAM Systems
Equafy	Esterel Technol ..	eXept Software ..	Experitest	Finaris	Froglogic
FrontEndART Ltd	GeneXus	GitHub project	gnoso	Google Code Pro ..	GrammaTech
Gurock Software	HelpSystems	HENIX	Hewlett Packard ..	Hexawise	High-Tech Bridg ..
Hiptest	Hitex	IBM Rational	imbus Shanghai	Impetus	Inflectra
informUp	InTENSO - IT Ex ..	Ipswitch	Jamo Solutions	Janova	JAR Technologie ..
JBoss Developer	jClarity	Jellly.io	JetBrains	Jively	jQuery foundati ..
JS Foundation	Jspresso	Kanoah	KMS Technology	Kualitee	LDRA Limited
Litmus	LoadFocus	Loadster Perfor ..	MarathonITE	Marketcircle	Marketcircle
Maveryx	Meliora Ltd	Micro Focus Sof ..	Microsoft	Mobile Labs	Mobile1st
Mockaroo, LLC	Monkop	Mozila	MSys Technologi ..	Navicat	NeoTys
Neowise Softwar ..	NetCart	NORIZZK.COM	Novosync Mobili ..	NRG Global	NTT Resonant
OC Systems	Odin Technology	OpCord	Oracle	Orcanos	Original Softwa ..
OW2	PANAYA	Parasoft	PassMark	Patterson Consu ..	Perfecto Mobile
Pivotal, Inc.	Plutora	Postman (API To ..	PractiTest	PrimaTest	Process One
Programming Res ..	Psoda	PureLoad	PushToTest	Python	Q-Assurance
QA Systems	QACube	QASymphony	QAWorks	QMetry	Quali
Qualitia Softwa ..	Quality First S ..	Quotium	RadView Softwar ..	Ranorex	RedLine13
Reflective Solu ..	ReQtest	RevDeBug	Robotium Tech	Rogue Wave Soft ..	Rommana Softwar ..
RTTS	ruby-doc.org	Runscope	Sandklef GNU La ..	Sauce Labs	Seapine Softwar ..
SeleniumHQ	Sencha	Sensiple	Siemens PLM Sof ..	SmartBear Softw ..	SmarteSoft
SOASTA	SoftLogica	Softomotive	Softsmith	Solution-Soft	SonarSource
Sourceforge	Spirent Technol ..	SQS Software Qu ..	Square	Stimulus Techno ..	Swifting AB
Synopsys	T-komp	T-Plan	TechExcel	TechTalk	Telerik By Prog ..
Tellurium	Test Collab	Test Goat	Test Recon	TestCaseLab	testCloud.de Gm ..
TestCraft Techn ..	Testenium	Testim.io	TestingBot	TestLodge	Testmunk
Testomato	TestOptimal	TestPlant	TestPro	Testsigma Techn ..	Testuff
The Core Bankin ..	The MathWorks	The Open Group	thePHP.cc	Thoughtbot	Thoughtworks
Tigris.org	Time Simulator	Top-Q	Trace Technolog ..	TrendIC	TRICENTIS
Tritusa Pty Ltd	TWD Solutions P ..	TypeMock	Tyto Software	Ubertesters	UniTESK
Universal Test ..	Usetrace Ltd	Utrecht Univers ..	Validata Group	Vanamco AG	Vector Software
Veracode	Verifaya Corpor ..	Verit	VersionOne	Viewlike.us	Vornex Inc.
Watir.com	WcfStorm Soluti ..	We Are Mammoth	Web Performance ..	Wintask	Wireshark Found ..
Worksoft	Xceptance	XK72	Xpand IT	XQual	ZAPTEST
Zeenyx Software ..	Zephyr	Zeta Software	zutubi pty

Acceptance-testing	Agile-testing
Application-Business-Logic	Automatic-Testing
Behavior-Driven-Development	Benchmark-testing
Black-Box-testing	Business-Flow-testing
Cloud-Based-Testing	Code-Coverage
Code-reviewing	Data-Driven-testing
Distributed-testing	End-to-End-testing
Exploratory-testing	Functional-testing
Hybrid-Testing	Integration-testing
Keyword-driven-testing	Load-Testing
Manual-testing	Model-Based-Testing
Monitoring	Object-Driven-Testing
Performance-testing	Regression-testing
Scalability-testing	Scrum-testing
Smoke-testing	Storyboard-testing
Test-Driven-Development	Traditional-Testing
Unit-testing	White-Box-testing

QATestingTools.com

Main menu

Tool Scope

Testing Methods

Testing Objectives

You are here

Error message