DBComp - Funduc Software

DBComp
Funduc Software

DBComp 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.

Usage Notes:

DBComp may not be practical with databases containing a lot of data. We do not have a specific "maximum size" recommendation but you should be aware that since DBComp employs exported data, processing time and disk space requirements will be considerable with large databases.
OBDC implementations currently do not reliably report which are the primary key(s) in a database. DBComp attempts to make a determination but if your primary are not the first few keys in a table or if NULLs are not allowed, you may need to edit the Difference File and specify the correct primary keys' offset(s). The offset number for the primary key in a table is specified on the Table= line in the Difference file.

Please see the program F1 Hlp and graphical page for additional usage notes and some usage suggestions.

Download: dbcomp.zip (Version 1.0 - 210K): Unzip this to the subdirectory of your choice. We recommend using c:\tools\DBComp although any path will do. See 'readme.txt' for more information.

BACK TO TEXT HOME

BACK TO GRAPHICAL HOME