DBComp - Funduc Software

DBComp

SITE GUIDE
Home Page

Utilities
Search & Replace
Directory Toolkit
Registry Toolkit
Folder Synch
File Merge Express
Update Toolkit
Application Mover
Application Inventory
Duplicate File Finder
Shortcut Doctor
Explorer Extensions
Drive Bar

Developer Products
Delivery Agent
WiseFontDLL
INI to Registry

Free Stuff
DBComp
Decode Shell Extension
Count Characters
Fold Synch Editor
FS ZIP Extractor
FS Hex Editor
DupBlock
TZAdjust
Limit Edit
HexView
INI to Registry
SR Wizard
WordSR
ExcelSR
PowerPoint SR

Courtesy Links
Search Engines
Shareware Links
Commercial Friends

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.

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.

DBComp - Main Dialog
DBComp Database Comparison

The DBComp Merge function is modeled here. Merge is used to take the results of a previous comparison and apply the changes to the 'Merge Data Source'.

The results of a previous comparison are in the file specified in the 'Merge File' field. This can be any file name you wish.

The changes are made via SQL. After clicking on the 'Merge' button a dialog is presented that lists the SQL statements. You can remove specific statements in advance or copy the them to the windows clipboard.

DBComp - Merge Dialog
DBComp Database Merge Function

Usage Notes:

BACK UP YOUR FILES FIRST!!! DBComp does not have an undo or auto-archive function of any kind. It is up to you to keep fresh backups.
DBComp is somewhat technical. Users who are familiar with database technology will understand the terminology and, hopefully, DBComp usage. If terms like "OBDC Data Source" are completely new to you then plan on spending some time experimenting before you proceed with usage on live data. We suggest you make up two small experimental databases and use them to practice on. One practice route is to make some differences between the two databases directly within your database program. Then try a comparison and look at the actual difference file produced. Then try updating the original Old Data Source using the difference file. Open up the Old Data Source dbase in your database program and check the results. Move on to live data only after you are satisfied with the results.
For a quick step-by-step guide, see Usage Guide1 and Usage Guide2. Those pages are repeats of information the F1 hlp.
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 for additional usage notes and some usage suggestions.

	Download Now (dbcomp.zip) Version 1.1 390K	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.
	Download Now (dbcomp.zip) Version 1.1 390K	Location #2

[Back] [Home]