Setting Object Filters

DBChangeManager provides options to specify the object types as well as specific object names that are to be included for comparison. Choose the Object Filter sub-tab in the Options tab and provide the necessary filter settings as described below.

Filtering Object Types:

To filter the necessary object types that are to be included for comparison, choose the 'Object Type Filter' link and check or uncheck the required object types to be included/excluded for comparison respectively. By default all the object types (both in SQL Server 2000 and SQL Server 2005) will be considered for comparison. Uncheck any of the object type(s) that you do not want to consider for this comparison.

Check 'Select All' if you want to select all the object types.

Filtering Objects by name:

To include only specific objects present in the database for comparison you could choose the 'Object Filter By Criteria' option to filter objects based on their names. Various name matching options are provided for filtering.

You could add a filter criteria as follows:

• Choose Object Type: First choose the type of schema object that is going to be matched from the first list box.
• Choose Matching Operation: Choose the type of matching operation that is to be applied. This could be any of 'Equals', 'Not Equals', 'Contains', 'Starts With', 'Ends With' and 'Does Not Contain' operation
• Provide the Criteria: In the last text field provide the object name string that is to be matched.
• Click 'Add' to add this Criteria for matching

You could add any number of criteria for filtering only the required objects that are to be considered for comparison. All the criteria will be 'AND'ed to fetch the objects for comparison.

Note: If a Criteria has been specified for an Object type that is excluded for comparison (Using 'Filtering by Object Types' option), the Criteria will not be effected.

Once you choose the objects to be compared, you could mention the Owner name mapping as discussed in the next chapter.