Tutorial - Update Oracle filters & ignore rules
Published 11 October 2021
Currently, there is no GUI in Flyway Desktop to customize the filter files. You can use Source Control for Oracle or Schema Compare for Oracle to configure the Filter.scpf file or edit it directly.
Ignore rules are recommended because they exclude the objects before the comparison runs and improves the performance.
Please refer to the Schema Compare for Oracle documentation for configuring ignore rules. (Here is the installer for Schema Compare for Oracle.)
Save the filter/ignore rule file to the root of the Flyway project.
Please refer to the Source Control for Oracle documentation for configuring ignore rules. (Here is the installer for Source Control for Oracle.)
Save the filter/ignore rule file to the root of the Flyway project.
You can edit the filter/ignore rule file in the root folder of your Flyway project in Notepad or another editor. Save your changes to the file and then use the Version control tab in Flyway Desktop to commit and push this filter file to the remote repository so all team members have the same filter settings.
Please refer to the filter file formats reference pages for more information.
Customizing the filter file path
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 filter file will be picked up automatically if it is named Filter.scpf and in the root of the Flyway project directory. Different path can be specified if desired in the project settings TOML file under redgateCompare.oracle.
[redgateCompare.oracle] ignoreRulesFile = "IgnoreRules.scpf" filterFile = "Filter.scpf"
