Creates a baseline of the given 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.
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
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 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. |
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.