Oracle Ignore Sequence Current Value Setting

Description

Ignores the current value of sequences when comparing and deploying databases.

If this option is set and you deploy a sequence, the current value of the target sequence is retained. Note: if the current value of the target sequence isn't within the MINVALUE and MAXVALUE limits of the source sequence, the current value will be reset to a default value.

If this option isn't set and you deploy a sequence, the current value of the source sequence is used as the current value for the target sequence.

Type

Boolean

Default

true

Usage

This setting can't be configured other than in a TOML configuration file.

Flyway Desktop

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

TOML Configuration File

[redgateCompare.oracle.options.ignores]
ignoreSequenceCurrentValue = true

Didn't find what you were looking for?