Using other Redgate products such as Source Control for Oracle and Schema Compare for Oracle, you can create filters and ignore rules for Oracle databases.

Ignore Rules

Ignore rules provide the capability to ignore certain database objects from any comparisons made. This potentially increases performance and helps to clear up comparison results, removing irrelevant database objects from the comparison reports.

Generating ignore rules

Ignore rules files can be generated by the following Redgate products. Only ignore rules for Oracle are currently supported. Links to the documentation pages for generating ignore rules files with the respective products are provided.

By default, ignore rules files are generated as IgnoreRules.scpf  in the root of the Source Control for Oracle or Schema Compare for Oracle project.

Adding ignore rules to your project

An ignore rules file will be picked up automatically if it is named IgnoreRules.scpf and in the root of the Flyway project directory. A different path can be specified if desired in the project settings TOML file under redgateCompare.oracle.

[redgateCompare.oracle]
ignoreRulesFile = "IgnoreRules.scpf"
filterFile = "Filter.scpf"

Filters

Filters do not remove database objects from the comparison, but do remove them from any comparison reports, and therefore do not improve performance, unlike ignore rules. However they are useful in some scenarios.

Generating a filters file

Filter files can be generated using Source Control for Oracle and are currently only supported for Oracle databases. Documentation on generating filter files can be found here.

By default files are generated as a Filter.scpf  file in the root of your Source Control for Oracle project.

Adding filters to your project

A filter file will be picked up automatically if it is named Filter.scpf and in the root of the Flyway project directory. A different path can be specified if desired in the project settings TOML file under redgateCompare.oracle.

[redgateCompare.oracle]
filterFile = "Filter.scpf"
ignoreRulesFile = "IgnoreRules.scpf"