CompareData is a native Microsoft Windows

Microsoft Windows

Microsoft Windows is a series of operating systems produced by Microsoft.Microsoft introduced an operating environment named Windows on November 20, 1985 as an add-on to MS-DOS in response to the growing interest in graphical user interfaces . Microsoft Windows came to dominate the world's personal...

 cross-DBMS database data comparison and synchronization tool that uses ODBC API to work with a wide-range of databases.

Architecture

CD uses native ODBC API, is written in C++ and is multi-threaded by design for enhanced performance on multi-core processors. A native 64-bit version of the application is also available that allows access to larger memory space.

CD is a client/server application and by default uses an embedded Firebird

Firebird (database server)

Firebird is an open source SQL relational database management system that runs on Linux, Windows, and a variety of Unix. The database forked from Borland's open source edition of InterBase in 2000, but since Firebird 1.5 the code has been largely rewritten ....

database as its backend to store comparison/task settings. The backend database is referred to as the application repository and can be hosted on most of the popular DBMSs in addition to the default Firebird DBMS.

License

No license is required for comparing table/view data or for Firebird data sources. For other functionality such as comparing metadata, comparing query data, synchronizing data or generating an SQL sync script a license is required after the 30-day evaluation period expires.

Three type of licenses are offered: Single-user license covers a single named user, site license and an enterprise license.

Functionality

A comparison item is made up of a pair of items such as two tables/views or two sql queries. Comparison items are organized in a workspace tree where all the comparison items for a folder can be processed one-by-one or as a group.

Data

You can compare the data of tables and views and also the data of sql queries. CD allows you to pair tables (i.e., select two tables as a comparison item), pair table columns and set up comparison options at column-level.

Metadata

CD uses ODBC catalog functions in addition to possibilly accessing DBMS metadata catalog tables using custom queries to retrieve metadata for tables including: table columns, primary key, index, imported foreign key, exported foreign key, privilege and triggers.

For popular databases CD also has functionality to compare stored procedures and sequences.

Synchronize

You can synchronize tables/view data at row-level, comparison item-level or folder level (all the comparison items for a folder). When synchronizing data at folder level, CD uses foreign key constraints to synchronize data in the correct order.

Synchronizing query data is currently not supported, but usually you can get around that by synchronizing the data of views.

CD uses ODBC bind parameters, prepared statements and bind offset pointers (if supported by the driver) for fast/efficient updates of database data.

Generate Sync Script

You can generate an sql data sync script at row-level, item level or folder level.

Scheduling

A compare, synchronize or generate sync script task may be scheduled internally or externally (using command line) for execution. A scheduled task results are written to the application repository and CD provides a hook procedure call for the task that allows custom processing at the end of a run.