Tutorial - Update PostgreSQL and MySQL filters
Published 02 December 2022
Currently, there is no GUI in Flyway Desktop to customize the filter files.
The filter file has to be manually created in one of two ways:
- create a file called
filter.rgf
in the project folder (next toflyway.toml
) - specify a particular file name in
flyway.toml
(underredgateCompare.filterFile
) and create that file instead
Example scenarios
These examples apply to all supported database engines i.e. PostgreSQL and MySQL
I want to ignore all objects of a particular type e.g. views Toggle source code
- {
- "version": "1.1",
- "postFilters":
- [
- {
- "filterBy": "objectType",
- "filterValue": "view",
- "effect": "exclude"
- }
- ]
- }
I want to ignore all properties of a particular name e.g. collations Toggle source code
- {
- "version": "1.1",
- "postFilters":
- [
- {
- "filterTarget": "property",
- "filterBy": "name",
- "filterValue": "collation",
- "effect": "exclude"
- }
- ]
- }
How do I ignore multiple property names and object types e.g. collations and all views Toggle source code
- {
- "version": "1.1",
- "postFilters":
- [
- {
- "filterBy": "objectType",
- "filterValue": "view",
- "effect": "exclude"
- },
- {
- "filterTarget": "property",
- "filterBy": "name",
- "filterValue": "collation",
- "effect": "exclude"
- }
- ]
- }
PostgreSQL specific example scenarios
These examples apply only to PostgreSQL and its variants
How do I ignore all privileges Toggle source code
- {
- "version": "1.1",
- "postFilters":
- [
- {
- "filterTarget": "property",
- "filterBy": "name",
- "filterValue": "privileges",
- "effect": "exclude"
- }
- ]
- }
How do I ignore all owners Toggle source code
- {
- "version": "1.1",
- "postFilters":
- [
- {
- "filterTarget": "property",
- "filterBy": "name",
- "filterValue": "owner",
- "effect": "exclude"
- }
- ]
- }