By default, SQL Change Automation will import all objects from the connected database when you generate migration scripts, including the Baseline script. It may be desirable to exclude certain objects, or even exclude entire schemas that you wouldn't want to deploy. Filters allow you to do this.

How to set-up filters

SQL Change Automation supports SQL Compare-compatible filter rules, which provide the flexibility to allow both include and exclude rules to be specified for your project. Filter runes can be set-up using the SQL Compare UI or by editing the filter files directly within a text editor (e.g. using the Visual Studio Xml document editor). Rules should be saved as a .scpf file to be used within your SQL Change Automation project.

When the SQL Change Automation is used to import new changes, the rules defined within the filter file will be applied: any objects that do not satisfy the rules will be excluded from the generated migrations, programmable objects and/or offline schema model.