To verify a table from the Data Administration tool:
1. Access the Data Administration, if you are not already there, and select DataServer > MS SQL Server Utilities > Verify Table Definition.
The following dialog box appears:
Note: You should not specify an entry that consists exclusively of wild cards for each of the three entry fields in the dialog box. An entry that consists exclusively of wild cards might degrade the performance of the database when you perform a schema pull. (It will include system catalog files from the data source not typically included in user databases.)
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 wild card 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 check box Verify only objects that currently exist in the schema holder.
4. There is a 32K limit on the contents of the verify report. Select Output differences to file if you anticipate a large volume of differences, or wish to save the report. The file that is produced will be named, ldbname+.vfy and will be written to the working directory.
5. Choose OK.
A dialog box like the following example lists the objects and table information that you preselected:
6. Select the objects that you want to update, then choose OK.
7. To select tables by matching a pattern, choose Select Some.
The following dialog box appears:
Note: You can also choose Deselect Some to deselect objects, using the identical matching a pattern options to deselect objects so they are not included in the schema holder.
8. Type the pattern that you want to match, then choose OK to start the verification.
If you did not choose to output the differences to a file, dialog boxes that list the objects and the verification results appears:
9. When reading the text of the report, SH indicates the value in the schema image; NS indicates the value in the MS SQL Server database.
For example:
10. Choose Close to return to the Schema Verify dialog box.
11. The utility automatically selects objects with severe differences for updating. You can select or deselect all other objects as you wish.
As there is no description column in the MS SQL Server database (NS), if the Schema image (SH) has objects with description column, then the utility discards these differences and are not shown in the report. Note that you must resolve retained differences manually. Retained differences appear in subsequent reports until you resolve them.
12. Choose OK to start the update or Cancel to quit the utility without updating the schema holder.
