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 Action | FDORA_COL_DROP_ACTION | No | Determines what action to take for "dropping" columns. Can be set to SET UNUSED or DROP. Defaults to SET UNUSED. |
Revert to Baseline ID | FDORA_REVERT_TO_BASELINE_ID | No | Numeric ID of the baseline to revert an environment to. Leave blank to choose not to revert to create a new baseline. |
Table Renames | FDORA_TABLE_RENAMES | No | Table rename string. |
Index Renames | FDORA_INDEX_RENAMES | No | Index rename string. |
Column Renames | FDORA_COLUMN_RENAMES | No | Column rename string. |
Trigger Renames | FDORA_TRIGGER_RENAMES | No | Trigger rename string. |
Constraint Renames | FDORA_CONSTRAINT_RENAMES | No | Constraint rename string. |
Synonym Renames | FDORA_SYNONYM_RENAMES | No | Synonym rename string. |
Sequence Renames | FDORA_SEQUENCE_RENAMES | No | Sequence rename string. |
View Renames | FDORA_VIEW_RENAMES | No | View rename string. |
...