...
- At this point the target FlexDeploy database should be an exact copy of the source database. Often times you will not need or want any of the execution details, so let's delete execution data using following commands. Make sure to run these commands on target FlexDeploy database. Keep in mind that in this process we have not copied artifact repository as goal was to not include execution details.
If there are errors in delete process below you can run it multiple times. In case of issues, please contact us at http://support.flexagon.com.
Code Block language sql theme RDark title Delete execution data in target FlexDeploy database delete from FD.ARC_PIPELINE_STAGE_EXEC_INFO; delete from FD.ARC_PIPELINE_STAGE_STEP_EXEC; delete from FD.ARC_PIPELINE_STAGE_GATE_EXEC; delete from FD.ARC_PIPELINE_STAGE_EXEC; delete from FD.ARC_PIPELINE_EXEC; delete from FD.ARC_REL_SNAPSHOT_VERSION_REQ; delete from FD.ARC_REL_SNAPSHOT_VERSION; delete from FD.ARC_REL_SNAPSHOT; delete from FD.PIPELINE_STAGE_EXEC_INFO; delete from FD.PIPELINE_STAGE_STEP_EXEC; delete from FD.PIPELINE_STAGE_GATE_EXEC; delete from FD.PIPELINE_STAGE_EXEC; delete from FD.PIPELINE_EXEC; delete from FD.REL_SNAPSHOT_VERSION_REQ; delete from FD.REL_SNAPSHOT_VERSION; delete from FD.REL_SNAPSHOT; delete from FD.REL_BUILD_MONITOR; delete from FD.TEST_DEF_QUALIFIER_VALUE; delete from FD.ARC_TEST_DEF_QUAL_VALUE; delete from FD.TEST_RESULT; delete from FD.ARC_TEST_RESULT; delete from FD.TEST_DEFINITION_RUN; delete from FD.ARC_TEST_DEFINITION_RUN; delete from FD.TEST_SET_QUALIFIER_VALUE; delete from FD.ARC_TEST_SET_QUALIFIER_VALUE; delete from FD.TEST_SET_RUN; delete from FD.ARC_TEST_SET_RUN; delete from FD.TEST_RUN; delete from FD.ARC_TEST_RUN; delete from FD.PLUGIN_EXECUTION_OUTPUT_VALUE; delete from FD.ARC_PLUGIN_EXEC_OUTPUT_VALUE; delete from FD.PLUGIN_EXECUTION_OUTPUT; delete from FD.ARC_PLUGIN_EXECUTION_OUTPUT; delete from FD.PLUGIN_EXECUTION_LOG; delete from FD.ARC_PLUGIN_EXECUTION_LOG; delete from FD.PACKAGE_OBJECT_EXECUTION; delete from FD.ARC_PACKAGE_OBJECT_EXECUTION; delete from FD.PLUGIN_EXECUTION; delete from FD.ARC_PLUGIN_EXECUTION; delete from FD.WORKFLOW_EXECUTION_DATA; delete from FD.ARC_WORKFLOW_EXECUTION_DATA; delete from FD.WORKFLOW_EXECUTION; delete from FD.ARC_WORKFLOW_EXECUTION; delete from FD.WORKFLOW_REQUEST_INPUT; delete from FD.ARC_WORKFLOW_REQUEST_INPUT; delete from FD.SCHEDULED_TASK; delete from FD.ARC_SCHEDULED_TASK; delete from FD.HUMAN_TASK; delete from FD.ARC_HUMAN_TASK; delete from FD.FOLDER_REQUEST_CURRENT_STATE; delete from FD.PROJECT_WF_CURRENT_STATUS; delete from FD.PACKAGE_OBJ_CURRENT_STATUS; delete from FD.WORKFLOW_REQUEST_INST; delete from FD.ARC_WORKFLOW_REQUEST_INST; delete from FD.WORKFLOW_REQUEST_CMS_ISSUE; delete from FD.ARC_WORKFLOW_REQ_CMS_ISSUE; delete from FD.WORKFLOW_REQUEST; delete from FD.ARC_WORKFLOW_REQUEST; delete from FD.FOLDER_REQUEST; delete from FD.ARC_FOLDER_REQUEST; delete from FD.FOLDER_PROJECT_VERSION; delete from FD.ARC_FOLDER_PROJECT_VERSION; delete from FD.PROJECT_VERSION_DATA_VAL; delete from FD.ARC_PROJECT_VERSION_DATA_VAL; delete from FD.PROJECT_VERSION_DATA; delete from FD.ARC_PROJECT_VERSION_DATA; delete from FD.PACKAGE_OBJECT; delete from FD.ARC_PACKAGE_OBJECT; delete from FD.PROJECT_VERSION; delete from FD.ARC_PROJECT_VERSION; delete from FD.FOLDER_VERSION; delete from FD.ARC_FOLDER_VERSION; delete from FD.PURGE_FOLDER_VERSION_KEY; delete from FD.PURGE_PROJ_VERSION_KEY; delete from FF.SEQUENCE_BLOCK where SEQ_NAM like 'stream-%'; delete from FD_ADMIN.PS_TXN; commit;
...