QArchive.ORG Main Page
Home | Blog | Terms of service | Sign in
All Vista Win Linux Mac
Related Products

DTM Data Comparer 1.14.06
Download Now
File Size: 1.2 Mb

DTM Data Comparer 1.14.06



Released:2012-11-26
License:$159.00
Publisher:DTM soft
Language:English
Platform:Vista, Windows, Mobile
Requirements:ODBC, OLE DB, IDAPI or Oracle Call Interface
Install:Install and Uninstall
Downloads:2072
Recommend DTM Data Comparer Suggest to Friend

Publisher's Description:

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.

List of Changes:

Version 1.14.00 from 2012-09-03

Show all changes

Version 1.10.00 from 2012-05-29

"Ignore quotation" comparison option.
New table list context menu.
Data type compatibility check was added.
Import and Export settings feature.

Version 1.09.08 from 2011-09-29

Better support for collations (SQL Server, Oracle, MySQL, PostgreSQL 9).
Table list refresh feature.
GUID conversion feature.
Better support for national strings comparison.

Version 1.08.01 from 2011-07-17

Value conversion feature added.
GUI performance enhancements.
Better support for SQL Server 2008 data types.

Version 1.07.00 from 2010-12-07

Important GUI changes (toolbars, status bar, layout)
Memory usage optimizations
New comparison report options and features

Version 1.06.00 from 2010-11-25

Face-to-face row comparison form.
Added comparison status indicator.
$DATE$ and $TIME$ macros for report and script file name.
New comparison settings.

Version 1.05.00 from 2010-11-15

Complete BLOB comparison support.
Important optimizations for large scale databases.
New options and redesigned settings window.
Added row comparison status icons.

Version 1.03.27 from 2008-10-24

New comparison and synchronization mode (database level).
Important interface changes.
Unicode version is now available.

Version 1.03.23 from 2008-05-28

New comparison and synchronization mode (database level).
Important interface changes.
Unicode version is now available.

Screenshot:

Tool for data comparison and synchronization
 

Download Now
File Size: 1.2 Mb

Share |


Text link code :
Hyper link code:
UBB/BLOG code:

Latest User Reviews:

naidu 2007-08-16 23:32:34 #
Version: 1.03.23

lots of erros with the demo tool

Internal product error.
Please send error report.
Code = 0xC0000005, Address = 0x40A25B
CLog state=CDcmpDlg::CompareTwoTables - rows ??? [0]
--------------------------------------
ERROR

2007-08-16 11:06:57 } << DTM Data Comparer DEMO 0,0,0,0 1.03.05, ANSI, x86>>
2007-08-16 11:06:57 } << build: Aug 3 2007 18:30:51,OS=5.01.2600 [Windows XP] Service Pack 2 >>
2007-08-16 11:06:57 } Start: Restore=1, sFile=, Recent File=, Load recent=1, Auto Comp=0, Auto Sync=0
2007-08-16 11:06:57 } db_info.cpp [407]
2007-08-16 11:06:57 } Loaded table '' not in m_Tables list (0 items)
2007-08-16 11:06:57 } db_info.cpp [407]
2007-08-16 11:06:57 } Loaded table '' not in m_Tables list (0 items)
2007-08-16 11:09:16 } codbc.cpp [544]
2007-08-16 11:09:16 } [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.,08001,17
2007-08-16 11:09:16 } codbc.cpp [547]
2007-08-16 11:09:16 } ODBC:: DriverConnect(DRIVER={DataDirect CLOSED 4.20 SQL Server Wire Protocol};UID=joliet;PWD=pcj123;SERVER=oracle;) [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.,08001,17
2007-08-16 11:10:26 } Connected to ODBC-0 Oracle [ 09.02.0040 ],SQORA32.DLL [ 09.02.0000 ] as joliet/joliet
2007-08-16 11:10:27 } Connected to ODBC-0 Oracle [ 09.02.0040 ],SQORA32.DLL [ 09.02.0000 ] as joliet/joliet
2007-08-16 11:25:14 } codbc.cpp [544]
2007-08-16 11:25:14 } connction string lacks some options,08001,202
2007-08-16 11:25:14 } codbc.cpp [547]
2007-08-16 11:25:14 } ODBC:: DriverConnect(DRIVER={PostgreSQL Unicode};UID=postgres;PWD=postgresql;SERVER=172.18.25.29;port=5432;DATABASE=) connction string lacks some options,08001,202
2007-08-16 11:25:48 } codbc.cpp [544]
2007-08-16 11:25:48 } connction string lacks some options,08001,202
2007-08-16 11:25:48 } codbc.cpp [547]
2007-08-16 11:25:48 } ODBC:: DriverConnect(DRIVER={PostgreSQL Unicode};UID=postgres;PWD=postgresql;SERVER=172.18.25.29;port=5432;DATABASE=) connction string lacks some options,08001,202
2007-08-16 11:26:16 } OCI: tnsnames.ora is not found. E:oracleora92NET80ADMINTNSNAMES.ORA
2007-08-16 11:26:16 } OCI.cpp [659]
2007-08-16 11:26:16 } TNS OCI: TNS file found 'E:oracleora92networkadmintnsnames.ora'
2007-08-16 11:26:29 } codbc.cpp [544]
2007-08-16 11:26:29 } connction string lacks some options,08001,202
2007-08-16 11:26:29 } codbc.cpp [547]
2007-08-16 11:26:29 } ODBC:: DriverConnect(DRIVER={PostgreSQL Unicode};UID=postgres;PWD=postgresql;SERVER=172.18.25.29;port=5432;DATABASE=) connction string lacks some options,08001,202
2007-08-16 11:36:34 } ODBC:: Connect (PostgreSQL30W,postgres,postgresql)
2007-08-16 11:36:34 } codbc.cpp [582]
2007-08-16 11:36:34 } FATAL: database "postgress" does not exist,3D000,210
2007-08-16 11:36:52 } ODBC:: Connect (PostgreSQL30W,postgres,postgresql)
2007-08-16 11:36:52 } codbc.cpp [582]
2007-08-16 11:36:52 } FATAL: database "postgress" does not exist,3D000,210
2007-08-16 11:37:26 } Connected to ODBC-1 PostgreSQL [ 8.2.4 ],PSQLODBC35W.DLL [ 08.02.0200 ] as postgres/
2007-08-16 11:37:30 } Connected to ODBC-1 PostgreSQL [ 8.2.4 ],PSQLODBC35W.DLL [ 08.02.0200 ] as postgres/
2007-08-16 11:37:30 } Connected to ODBC-1 PostgreSQL [ 8.2.4 ],PSQLODBC35W.DLL [ 08.02.0200 ] as postgres/
2007-08-16 11:41:57 } CompAndSync(single): Con=0 [ADUSR001MT<->joliet.adusr001mt], columns[36,36], map[36,36], mode='DIU'
2007-08-16 11:41:57 } CompAndSync: Rep:'', Out:'', dcmp:''
2007-08-16 11:51:44 } Connected to ODBC-1 PostgreSQL [ 8.2.4 ],PSQLODBC35W.DLL [ 08.02.0200 ] as postgres/
2007-08-16 11:51:46 } Connected to ODBC-1 PostgreSQL [ 8.2.4 ],PSQLODBC35W.DLL [ 08.02.0200 ] as postgres/
2007-08-16 11:51:46 } Connected to ODBC-1 PostgreSQL [ 8.2.4 ],PSQLODBC35W.DLL [ 08.02.0200 ] as postgres/
2007-08-16 11:51:52 } idxPK for 'joliet.provider' is empty [Fld=76,PK=1]
2007-08-16 11:52:26 } CompAndSync(single): Con=0 [ADUSR001MT<->joliet.provider], columns[76,76], map[0,0], mode='DIU'
2007-08-16 11:52:26 } CompAndSync: Rep:'', Out:'', dcmp:''
2007-08-16 11:57:10 } CompAndSync(single): Con=0 [ADUSR001MT<->joliet.provider], columns[76,76], map[0,0], mode='DIU'
2007-08-16 11:57:10 } CompAndSync: Rep:'', Out:'', dcmp:''
2007-08-16 11:57:37 } Unhandled Exception Internal product error.
Please send error report.
Code = 0xC0000005, Address = 0x40A25B
CLog state=CDcmpDlg::CompareTwoTables - rows

2007-08-16 11:58:05 } << DTM Data Comparer DEMO 0,0,0,0 1.03.05, ANSI, x86>>
2007-08-16 11:58:05 } << build: Aug 3 2007 18:30:51,OS=5.01.2600 [Windows XP] Service Pack 2 >>
2007-08-16 11:58:06 } Start: Restore=1, sFile=, Recent File=, Load recent=1, Auto Comp=0, Auto Sync=0
2007-08-16 11:58:06 } db_info.cpp [407]
2007-08-16 11:58:06 } Loaded table '' not in m_Tables list (0 items)
2007-08-16 11:58:06 } db_info.cpp [407]
2007-08-16 11:58:06 } Loaded table '' not in m_Tables list (0 items)
2007-08-16 11:58:50 } codbc.cpp [544]
2007-08-16 11:58:50 } connction string lacks some options,08001,202
2007-08-16 11:58:50 } codbc.cpp [547]
2007-08-16 11:58:50 } ODBC:: DriverConnect(DRIVER={PostgreSQL Unicode};UID=joliet;PWD=pcj123;SERVER=oracle;port=5432;DATABASE=) connction string lacks some options,08001,202
2007-08-16 11:59:12 } Connected to ODBC-0 Oracle [ 09.02.0040 ],SQORA32.DLL [ 09.02.0000 ] as joliet/
2007-08-16 11:59:14 } Connected to ODBC-0 Oracle [ 09.02.0040 ],SQORA32.DLL [ 09.02.0000 ] as joliet/
2007-08-16 11:59:31 } Connected to ODBC-0 Oracle [ 09.02.0040 ],SQORA32.DLL [ 09.02.0000 ] as joliet/
2007-08-16 11:59:31 } Connected to ODBC-0 Oracle [ 09.02.0040 ],SQORA32.DLL [ 09.02.0000 ] as joliet/
2007-08-16 11:59:40 } Connected to ODBC-1 PostgreSQL [ 8.2.4 ],PSQLODBC35W.DLL [ 08.02.0200 ] as postgres/
2007-08-16 11:59:40 } Connected to ODBC-1 PostgreSQL [ 8.2.4 ],PSQLODBC35W.DLL [ 08.02.0200 ] as postgres/
2007-08-16 12:00:24 } idxPK for 'joliet.provider' is empty [Fld=76,PK=1]
2007-08-16 12:00:28 } CompAndSync(single): Con=0 [JOLIET.ADUSR001MT<->joliet.provider], columns[76,76], map[0,0], mode='DIU'
2007-08-16 12:00:28 } CompAndSync: Rep:'', Out:'', dcmp:''



Pushkaraj 2007-08-03 07:03:44 #
Version: 1.03.23

Sybase Database

Does the tool compares data in Sybase database?




Download Now
File Size: 1.2 Mb



Search