The way the changes are captured in the schema model and migration scripts can be configured using the Schema Compare for Oracle options.

These can be configured in the project settings file under capabilities.comparison.options, using the option name as the key.  The full list of options is listed below:

"capabilities": {
    "comparison": {
        "ignoreRules": "./IgnoreRules.scpf",
        "filter": "./Filter.scpf",
        "options": {
            "ExcludeTargetSchemaName": true
        }
    }
}

It is also possible to read a Source Control for Oracle options file with the capabilities.comparison.optionsFile setting.  It may be easier to configure your options using Source Control for Oracle and then saving the ComparisonOptions.xml to your repo.

"capabilities": {
    "comparison": {
        "ignoreRules": "./IgnoreRules.scpf",
        "filter": "./Filter.scpf",
        "optionsFile": "./schema-model/ComparisonOptions.xml"
    }
}

Default options

• Ignore Permissions  - this is set to true because Flyway Desktop is generating migration scripts to ultimately deploy to production, and it is unlikely that development permissions should be deployed to production.

Hard-coded options

The following options are hard-coded and cannot be altered:

Full list of options

The full list of options is below.  Read more about each one on the Schema Compare for Oracle page.