You can create filters to exclude objects from SQL Source Control.
When you exclude an object with a filter, it isn't shown on the Commit changes tab, the Get latest tab, or the Undo changes dialog box. This means you can never commit, get, or undo an excluded object. This is useful, for example, if there's a set of objects that you never want to commit.
There are two ways to create or edit your filter:
The Edit filter rules tab lets you specify exclusion or inclusion conditions for individual objects or all object types:
You can exclude object types using the check boxes in the left-hand pane, or build more complex conditions by specifying AND clauses and OR conditions in the right-hand pane.
When you create a filter rule, its conditions are displayed in the left-hand pane under the name of the object type it applies to:
To clear the filter rule for an object type, click next to its name.
To exclude all objects with names beginning with Marketing, or any owned by the schema Marketing, regardless of their names:
The Edit Filter Rules dialog box is displayed.
A new OR condition becomes available.
The filter is applied. All objects owned by the schema Marketing or with names that begin with Marketing are excluded by SQL Source Control and won't appear in the Commit changes tab.
You can commit your filter to source control and get the latest version when it changes. This is useful for teams that want to exclude a set of objects across an entire development project.
When you create or edit a filter, SQL Source Control shows it on the Commit changes tab:
You can see the differences between your current filter and the version in source control.