Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Creates a baseline of the input given schema name.

A file artifact is created which references a set of DDL in the DDL repositoryRepository. This file is then used by the synchronize operation to update the DDL of a target database to the version specified by the build operation's Revert to Baseline ID value if specified, or the current version if Revert to Baseline ID is left blank.

Specifying a previous Revert to Baseline ID value will create an artifact that when deployed will bring the target database DDL to that baseline.

Leaving   Revert to Baseline ID blank will create an artifact that when deployed will bring the target database DDL to the current DDL of the Source Database.

Environment/Instance Properties

...

Input Name

Input Code

Required

Description

Column Drop ActionFDORA_COL_DROP_ACTIONNo

Determines what action to take for "dropping" columns.

Can be set to SET UNUSED or DROP.

Defaults to SET UNUSED.

Revert to Baseline IDFDORA_REVERT_TO_BASELINE_IDNo

Numeric ID of the baseline to revert an environment to.

Leave blank to choose not to revert to create a new baseline.

Table RenamesFDORA_TABLE_RENAMESNo

Table rename string.


Index RenamesFDORA_INDEX_RENAMESNo

Index rename string.


Column RenamesFDORA_COLUMN_RENAMESNo

Column rename string.


Trigger RenamesFDORA_TRIGGER_RENAMESNo

Trigger rename string.


Constraint RenamesFDORA_CONSTRAINT_RENAMESNo

Constraint rename string.


Synonym RenamesFDORA_SYNONYM_RENAMESNo

Synonym rename string.


Sequence RenamesFDORA_SEQUENCE_RENAMESNo

Sequence rename string.


View RenamesFDORA_VIEW_RENAMESNo

View rename string.


...