Progress
DataServer for
Microsoft SQL Server
Guide


Verifying a Schema Holder

The Verify Table Definition utility allows you to verify that the schema holder for your data source matches the data definitions in the data source. For example, if you delete the Customer table from the data source but not from the schema holder, this utility reports that the schema holder contains an orphaned object. You can verify the schema information in a single table or from multiple tables, and then choose to update the tables so that the schema information matches the data source definitions.

The Verify utility reads the definitions in the data source and compares them to the information in the schema holder. It reports the differences that it finds and their degree of severity. These are the categories of differences and how they impact your database applications:

Table 5–3 lists the differences that this utility detects.

Table 5–3: Verify Utility Report
Database Object
Difference
Category
Table
Description
Retained
Table
Foreign type
Severe
Table
Name in Progress
Retained
Table
Package name
Severe
Table
ROWID index
Retained
Index
Active
Minor
Index
Description
Retained
Index
Name in Progress
Retained
Index
Unique
Retained1
Index field
Abbreviated
Minor
Index field
Ascending
Severe
Index field
Order
Severe
Field
Case sensitivity
Retained
Field
Decimals
Retained2
Field
Description
Retained
Field
Extent
Severe
Field
Initial value
Retained2
Field
Mandatory
Retained
Field
Name in Progress
Retained
Field
Order
Retained
Field
Progress data type
Retained2
Field
Progress format
Retained2
Field
Shadow-column Name
Severe
  1. When you update an index, it is flagged as unique if it was defined as unique in the data source or the schema holder.
  2. If the corresponding information in the data source is incompatible with the information in the schema holder, the affected fields are not updated. For example, if the data source data type is decimal and the Progress data type is CHARACTER, the data-type information is not updated.

To verify a table, follow these steps:

  1. Access the Progress Data Administration tool, if you are not already there, and select DataServer MS SQL Server Utilities Verify Table Definition. The following dialog box appears:
  2. Type preselection criteria values into the fields if desired. These values preselect the data source objects that the utility uses to update the schema holder. By default, the wildcard symbol (*) appears; it specifies that the utility uses all of the objects in the data source.
  3. By default, the utility verifies objects in the schema holder that match objects in the data source. To check whether there are objects in the data source that are not represented in the schema holder, deselect the toggle box labeled “Verify only objects that currently exist in the schema holder.”
  4. Choose OK. A dialog box lists the objects and table information that you preselected, for example:
  5. Select the objects that you want to update, then choose OK.
  6. To select tables by matching a pattern, choose the Select Some button. The following dialog box appears:
  7. Type the pattern that you want to match, then choose OK to start the verification. A dialog box that lists the objects and the verification results appears.
  8. If on UNIX, choose the View Reports button to view a description of the differences found. On Windows, the Schema-Verify-Detected differences automatically displays, as shown below:
  9. Choose Close to return to the Schema Verify dialog box.
  10. The utility automatically selects objects with severe differences for updating. You can select or deselect all other objects as you wish. Note that you must resolve retained differences manually. Retained differences appear in subsequent reports until you resolve them.
  11. Choose OK to start the update or Cancel to quit the utility without updating the schema holder.

Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095