Pre-requisites

• Check for drift - if drift is detected, scripts to help with drift resolution will be generated in the drift-resolution folder under your working directory. The working directory can be specified explicitly and will otherwise be the command-line current working directory.

Tutorial steps

Copy the generated filter file from the drift-resolution  folder to your project root directory, overwriting your existing filter file, if present. The generated filter file should contain all the existing configurations from your existing filter file, with the drift exclusions added on top, but you may want to verify this before overwriting.

For SQL Server projects the filter file will be named Filter.scpf. For Oracle projects the filter file will be named IgnoreRules.scpf.

If you re-run the drift check it should now pass, and any deployment scripts will ignore the drifted objects.

Note that it is also possible to rename the filter file and use it to override the filter when working with a specific database, by using the check.filterFile setting when running check drift, or by overriding the database specific command (filterFile for SQL Server and ignoreRules for Oracle). But be aware that this replaces any existing filter file and does not get added on top.

Further information

• Drift analysis concept
• Checking production environments for drift