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:

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

It is also possible to read a SQL Source Control for Oracle options file with the capabilities.comparison.optionsFile setting:

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

Default options

• Ignore Permissions  - this is set to true because Redgate Change Control 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: