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.
Please refer to the Schema Compare for Oracle documentation for configuring ignore rules.
Please refer to the Source Control for Oracle documentation for configuring ignore rules.
You can edit the filter 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"
