DBComp, one of our freeware products, is a database comparison and merge application. The program performs two basic tasks:

1) The Compare Data Sources function compares two OBDC data sources for alike vs. different records and generate a Difference File that lists the records that either do not match or have been added/deleted from one data source compared to the other.

2) The Merge function examines a Difference File generated by DBComp and updates the specified data source via SQL statements. You can view the SQL statements in advance and remove one (or more) in advance if you wish.

DBComp can be used to update remote data sources when it is impractical or inefficient to distribute an entire copy of the database to the remote location. The program can also be used to examine a data source against an archived (older) copy for the purposes of debugging or historical examination.