Defining a compare request

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 Help > Contents, right-clicking an item and selecting What's This, or by pressing F1.

To define a compare request:

  1. In the Directory Explorer, right-click Compare and click New Compare. The Compare Request Editor opens.
  2. In the General tab, complete the following steps:
    1. Enter a compare file name in the Compare File field.
    2. Select Browse Results Immediately to view the results of the compare process after the process is competed.
    3. 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.
  3. In the Source tab, select the data sources to compare based on the comparison mode.
  4. Click File > Run to begin the compare process.
  5. Click File > Saveto 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.



Feedback