Use the Compare Request Editor to define data sources to
compare and processing options.
Use the help facility in the Compare utility to obtain
more information about a specific topic or function. You can open
a help window by selecting , right-clicking an item
and selecting What's This, or by pressing F1.
To
define a compare request:
- In the Directory Explorer, right-click Compare and
click . The Compare Request Editor opens.
- In the General tab, complete the
following steps:
- Enter a compare file name in the Compare
File field.
- Select Browse Results Immediately to
view the results of the compare process after the process is competed.
- Select a Comparison mode.
- Single Table
- Source File – Source File
- Compare data in a single table in one source file
with data in another source file.
- Source File – Database Table
- Compare data in a single table in a source file
with data in a single table in the database.
- Database Table – Database Table
- Compare data in a single table in one database with
data in a single table in another database.
- Multiple Tables
- Source File – Source File
- Compare the data in tables in one source file with
data in another source file.
- Source File – Access Definition
- Compare the data in tables in a source file with
the data specified in an access definition.
- Source File – All Database Tables
- Compare the data in tables in a source file with
data in a database.
Note: This selection is extremely useful when
testing a database application. The source file represents the “before”
image compared with the database tables, which represent the “after”
image.
- Access Definition – Access Definition
- Compare the data specified in one access definition
with data specified in another access definition.
- Access Definition – All Database Tables
- Compare the data specified in an access definition
with data in a database.
- In the Source tab, select the data
sources to compare based on the comparison mode.
- Click to begin the compare process.
- Click to save the compare request. Enter a request name in
the format IDENTIFIER.NAME.
The process will create a compare file in the data directory
specified in the Configuration utility. Use the Browse utility to
view the results of the comparison.