SQL Compare - 10.0

SQL Compare

Using filters - SQL Compare

You can use filters to define which objects are displayed in the upper (Results) pane. For example, you may be interested in only tables, or in only some of the stored procedures owned by a specific schema. You can set up a filter to show you only the objects matching these conditions.

You can set up a filter for object types, and edit the filter rules to restrict which specific objects are included in or excluded from the upper pane.

The default filter is Nothing Excluded. If you edit this filter, Custom* is shown in the Filter box. An asterisk is displayed next to the name of any filter you edit, to show that there are unsaved changes.

You can save your filters for use in multiple projects. To choose a different filter, in the Filter box select the filter you want to use; if the filter is not listed, select Open filter from file and browse to the filter.

Filter rules

You can define which object types the filter includes in the comparison results using the object type check boxes in the Filter pane.

You can also create rules to control the specific objects that a filter includes or excludes. To edit the filter rules:

On the Filter pane, click Edit Filter Rules.

The Edit Filter Rules dialog box is displayed:

You can select individual object types or All object types in all schemas, and edit the rules applying to those objects.

When you create a filter rule, its conditions are displayed under the name of any object types it applies to.

To edit the filter rule for an object type, move the mouse pointer over it and click the (Edit) button that becomes available:

To clear the filter rule for an object type, move the mouse pointer over it and click the (Clear) button that becomes available.

You can clear all current filter rules by selecting the filter Nothing Excluded from the Filter box.

Saving and deleting filters

Saved filters are available in subsequent projects, and can be selected from the Filter box. Saved filters have the file extension .scpf

  • To save the current filter, on the Filter pane, click Save

    In the Save Filter dialog box, type the name for the filter.

    When you save an edited filter, you can either save it with the same name to overwrite it, or change the name to create a new filter.

  • To delete the current filter, on the Filter pane, click Delete

    You will be prompted to confirm. When you delete the current filter, Custom* is shown in the Filter box, and the conditions for the filter you just deleted remain set until you select another filter or make any changes.

Note that any unsaved changes to a filter are lost when you select another filter.

Filters and Find

A filter defines which objects are displayed in the upper (Results) pane; using Find changes how those objects are grouped. So, if an object matches the term in the Find box, and is excluded by a filter, it is not displayed in the upper pane.

Find groups results by whether they match or do not match the term typed in the Find box. Objects not matching the find term are still displayed in the upper pane, although this group is shown as collapsed by default.

Only objects displayed in the upper pane can be selected for deployment.

Example: excluding objects by type

If you want to view comparison results for only Tables and Views:

  1. On the Filter pane, select and clear the All object types included check box.

    This ensures that no objects are displayed in the upper (Results) pane.

  2. Select the View and Table check boxes.

The filter is applied. Only tables and views are displayed in the upper pane.

Example: Excluding objects from a specific schema

If you want to view comparison results that exclude any objects owned by the schema Marketing:

  1. On the Filter pane, click the Edit Filter Rules button.

    The Edit Filter Rules dialog box is displayed.

  2. In the For box, ensure that All object types in all schemas is selected.
  3. In the box, select Exclude if.
  4. Under Property, select Schema name.
  5. Under Operator, select Equals.
  6. Under Value, type Marketing.
  7. Click OK.

The filter is applied. No objects owned by the schema Marketing are displayed in the upper pane.

Example: including only those tables with a specific name or a particular owner

If you want to view comparison results for all the tables that have names beginning with Marketing, as well as all those owned by the schema Marketing, regardless of their names:

  1. On the Filter pane, select and clear the All object types included check box.

    This ensures that no objects are displayed in the upper pane.

  2. Click the button for Table.

    The Edit Filter Rule dialog box is displayed.

  3. In the box, select Include if.
  4. Under Property, select Object name.
  5. Under Operator, select Begins with.
  6. Under Value, type Marketing.
  7. Click

    A new OR condition becomes available.

  8. Under Property, select Schema name.
  9. Under Operator, select Equals.
  10. Under Value, type Marketing.
  11. Click OK.

The filter is applied. Only objects owned by the schema Marketing, or with names that begin with Marketing are displayed in the upper pane.

Filters and deployment

The current filter affects which objects you can select for deployment:

  • When you use the filter to exclude an object or object type, it is removed from the upper pane and cannot be selected for deployment.
  • If you select an object for deployment and later set up a filter that excludes it, the object is not deployed.

Objects excluded by the filter are only included in the deployment as dependencies. If an excluded object is referenced by an object you selected for deployment, you will be notified of this dependency, and can choose to deploy the affected object on the Review Dependencies page of the Deployment wizard.

See also

Setting up the deployment

Viewing the comparison results

Was this article helpful?

Search support
Forums
Visit the SQL Compare forum.
Learning SQL Compare
Knowledge base

SQL Compare

all SQL products

all products

Notes & articles

SQL Compare

all SQL products

all products

Demos & walkthroughs

SQL Compare