Action Plans can be exported from a Stages Server and imported into another Stages Server. The export utility is run on the source SQL Server and will produce an SQL script that is used to import the Action Plan to the destination Server. The Action Plan # is specified. The most recent active version of the Action Plan is exported. This includes all variations. When the Action Plan is imported, it will be inactive on the destination Server. The imported Action Plan is automatically copied to all redundant Stages Servers. The user can use the Stages application to view the Action Plan on the destination Server. The user can then activate the new version of the Action Plan.
To Export the Action Plan:
- Connect to the source SQL Stages Database with the SQL user StagesInstaller.
- Execute the below SQL Statement.
pExportActionPlan @ActionPlanNum = xxxx(xxxx is the Action Plan # to export.)
To Import the Action Plan:
- Connect to the destination SQL Stages Database with the SQL user StagesInstaller, and execute the Script.