ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Database rollback SQL for DevTest upgrade


Article ID: 126451


Updated On:


CA Application Test Service Virtualization CA Continuous Application Insight (PathFinder)


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?


Component: ITKOTF


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

and the product documentation:
Preparing Your DevTest Upgrade -