Redgate Flyway

Preview Feature

This feature is currently available in Preview. If you use this feature, please let us know.

Description

Adds existence checks to scripts to improve their ability to be re-run multiple times without encountering “already exists” errors.

When this option is active the script will include an existence check before attempting to create an object.

Creation statements for the following objects are supported:

Indexes

Type

Boolean

Default

false

Usage

Flyway Desktop

This can be set from the comparison options settings in Oracle projects.

Command-line

      
        .
        /flyway
         
        generate
         
        -redgateCompare
        .
        oracle
        .
        options
        .
        behavior
        .
        objectExistenceChecks
        =
        true
        

      
    

TOML Configuration File

      
        [redgateCompare.oracle.options.behavior]
objectExistenceChecks = true