DBComp 1.1

DBComp, one of our freeware products, is a database comparison and merge application DBComp, one of our freeware products, is a database comparison and merge application. This application 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.
An example DBComp Comparison function is shown here.
The Data Sources are selected via the ... buttons to the right of the fields. The program relies on OBDC so you will need to configure your OBDC data sources in advance. Do this from Control Panel.
After clicking on the Update button the two data sources are read and the tables available are listed.
Data Difference Path is where a difference file summarizing changes between the two data sources is saved. This file is an ordinary text file that you can modify with your text editor if necessary.