In the event that we have to back out our Harvest SCM Server upgrade what is the recommended method for rolling back the database upgrade?

book

Article ID: 38108

calendar_today

Updated On:

Products

CA Harvest Software Change Manager - OpenMake Meister

Issue/Introduction

Question: 

After upgrading the Harvest SCM Server if a problem develops for which there is not a quick answer, it might be decided that the upgrade should be "backed out" and Harvest SCM returned to the previous version.  In this situation, how can the changes made to the Harvest SCM database during the upgrade be "backed out" so that the database is returned to the previous schema level?

Environment:  

Harvest SCM Server, all versions, all platforms

Answer: 

After all users have logged out of Harvest and the broker shut down, before the upgrade of Harvest SCM Server begins, it is highly recommended that a full backup of the database be made so that functionality can be restored if something goes wrong.  Changes to the Harvest SCM database cannot be "rolled back" once the upgrade to the database has completed successfully.  You will need to restore the previous version of the Harvest SCM database from the backup that was made just before the upgrade process began.

Environment

Release: SCMNCR99000-12.5-Harvest-Software Change Manager-Named User-Competitive Replacem
Component: