|
|
|
Compare and synchronize IBM DB2 databases with DTM Data Comparer
DTM Data Comparer provides DBA or database developer a visual way to compare or
even synchronize DB2 databases. However, unattended console mode
for scheduled comparison and synchronization is also available.
DTM Data Comparer fetches data rows of tables to be compared basing on the order of ascending of primary key or user
defined unique key values. If the program can't find data rows with the same key value, it places the records to different grid lines
and highlights row by yellow background. In case values of the keys coincide, the program places them to the same lines and highlights cells for equal fields by
green background and different fields by red background.
The comparison tool provides a way to compare tables with different structure. It is a column mapping feature.
Moreover, some conversion by built-in DB2 functions can be applied to target table during data synchronization. For example, the
user can change date format by DATE function.
Download free demo version(?).
Key product features
- The software can compare tables in DB2 tables as well as to compare DB2 table with another data source like MySQL or even Excel spreadsheet.
- You can compare data at different platforms: the comparer launched at windows system can compare databases at Linux and AIX systems over network.
- Rich comparison report with two modes allows the user to understand differences between tables or databases.
- Mapping and conversion features makes comparison and synchronization more flexible.
- DTM Data Comparer is a true Win32 application, supports Windows 2000, XP, Vista, Windows 7, Windows Server 2003/2008. x64 version of the tool is
available for registered users.
Why DTM Data Comparer
- Uses ODBC driver for DB2, no additional software is required.
- Custom key definition enables the user to compare DB2 data with desktop databases or spreadsheets (Excel, DBF, Access, etc).
- High comparison performance. The user can compare millions of rows with this tool.
- Powerful yet simple user interface for database professionals.
- Unattended mode allows execution by task schedulers. The user can run comparison or synchronization process on a schedule, over night etc.
See also
|
More screenshots, Video Tour
|
|
|
|
|
|
|
|
See also
|
|
Articles
|
|
|
|
Related Products
|
|
|
|
|
|
|
|
|
|
|
|
• On-line