Database rollback SQL for DevTest upgrade

book

Article ID: 126451

calendar_today

Updated On:

Products

CA Application Test Service Virtualization CA Continuous Application Insight (PathFinder) CA Service Virtualization (DevTest / LISA / VSE / Application Test)

Issue/Introduction



As a part of the DevTest upgrade process the DBA will be running the DDLs required to upgrade the database. In case of any issues, we would need rollback DDL/DMLs to revert the changes.
Where can I find the rollback SQLs for Oracle?

Environment

Release:
Component: ITKOTF

Resolution

As of now, we do not provide rollback scripts.
The recommendation is to have a backup of your database and the entire existing DevTest folder. This would take care of the following which are important files in your installation:
This would take care of the following which are important files in your installation: 
. Properties files (local, site, lisa and dradis)
. Virtual Services (if stored locally)
. Application Test tests (if stored locally)
. HotDeploy folder  
. vseDeploy folder
. lib
. any custom folders

A rollback script can be designed, however we have very limited support for this type of customization.

Additional Information

For information regarding DevTest upgrade, please refer to the Upgrade Center under DevTest Communities:
DevTest Solutions Upgrade Center https://communities.ca.com/docs/DOC-231171434-devtest-solutions-95-upgrade-center

and the product documentation:
Preparing Your DevTest Upgrade - https://docops.ca.com/devtest-solutions/10-4/en/installing/preparing-your-devtest-upgrade