These steps can be useful if you are installing a new FlexDeploy environment, and want to load it with specific configurations from a different environment with the same FlexDeploy version.
These steps are provided as guidelines and extreme care must be taken to not disrupt your production environments.
This process should only be followed to perform configuration setup for brand new installation of FlexDeploy from another installation of FlexDeploy. Purpose of this document is to only copy configuration details and not execution data. If you run this against active Production FlexDeploy, you will lose all execution details. This process is only applied for 4.5 version of FlexDeploy. Also, source and target version of FlexDeploy must be the same. |
This step will create fd_bkup.dmp file with all details from FD,FF and FD_ADMIN schemas. File should be in data pump directory, for example - C:\oraclexe\app\oracle\admin\XE\dpdump.
expdp system directory=DATA_PUMP_DIR dumpfile=fd_bkup.dmp schemas=FD,FF,FD_ADMIN |
Make sure there are no errors in import process. If there are errors, make corrections appropriately and restart import process.
impdp system directory=DATA_PUMP_DIR dumpfile=fd_bkup.dmp schemas=FD,FF,FD_ADMIN |
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.
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.PACKAGE_OBJ_CURRENT_STATUS; 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.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; |