Creates a baseline of the input schema name.
A file artifact is created which references a set of DDL in the DDL repository. 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.
Environment/Instance Properties
Property Name | Property Code | Required | Description |
|---|---|---|---|
Oracle Database URL | FDORA_URL | Yes | The JDBC URL for the target Oracle database. |
| Oracle Database User | FDORA_USER | Yes | The username that will be used to connect to the target Oracle Database. |
| Oracle Database Password | FDORA_PASSWORD | Yes | The password for Oracle Database User. |
| Target JDBC Driver Path. | FDORA_DRIVER_PATH | Yes | Path containing JDBC driver for target database connection. |
| DDL Repo JDBC Driver Path | FDORA_DDL_DRIVER_PATH | Yes | Path containing JDBC driver for DDL repository database connection. |
| DDL Repository URL | FDORA_DDL_URL | Yes | The JDBC URL for the DDL repository. |
| DDL Repository User | FDORA_DDL_USER | Yes | The userid used to connect to the DDL repository. |
| DDL Repository Password | FDORA_DDL_PASSWORD | Yes | The password for the DDL repository userid. |
Project Properties
Property Name | Property Code | Required | Description |
|---|---|---|---|
| Oracle Database Schema Name(s) | FDORA_SCHEMA_NAME | Yes | Comma-separated list of schemas controlled by this project. |
Inputs
| 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 a 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. |
Outputs
Output Name | Required | Description |
|---|---|---|
| No | Outputs the BaseLine ID which was built. |
FDORA_OUT_BL_TABLE_COUNT | No | |
FDORA_OUT_BL_INDEX_COUNT | No | |
FDORA_OUT_BL_CONSTRAINT_COUNT | No | |
FDORA_OUT_BL_SEQUENCE_COUNT | No | |
FDORA_OUT_BL_PROCEDURES_COUNT | No | |
FDORA_OUT_BL_VIEWS_COUNT | No | |
FDORA_OUT_BL_SYNONYMS_COUNT | No | |
FDORA_OUT_BL_MVIEW_COUNT | No | |
FDORA_OUT_BL_MVIEW_LOG_COUNT | No | |
FDORA_OUT_BL_PRIVILEGES_COUNT | No |
Artifacts
This operation produces artifacts that will be stored in the artifacts repository. This artifact is an empty file whose name is used to select a revision from the DDL Repository.
Endpoint Selection
This operation will select all available endpoints associated to the environment/instance.
Endpoint Execution
This operation will execute on any one of the selected endpoints and will be random in the determination of which one.
Special Considerations
[Delete section if not needed]
Describe any dependencies between properties that may exist or anything that that isn’t really covered above but is relevant to this operation.