Cleanup unused tables from Data schema after upgrade in Production
We did upgrade from 6.2 to 7.2.1 from single schema to split schema and cleaned up the unused rule tables from Data schema using Optimize schema wizard. This is in Development environment hence our production level is 2 and we had all the privileges to see optimize schema wizard.
Now, we are writing down steps for Production upgrade and we found out there are two ways to do this,
1. Change production level to 2 in PROD environment and execute optimize schema wizard to cleanup OR
2. Collect all the cleanup queries from Lower environment and run it manually on the DB side for PROD.
But, apart from these steps is there any PEGA command line utility to do this job in Production?
If not which option(1 OR 2) mentioned above will be a best fit in production environment?
Looking forward for a quick answers from experts who performed the upgrade in Prod.
In order to get the optimization wizard we need to set the production level to 2 in PROD environment and then after finishing the process we need to reset it back to 5. These are manual steps which we want to avoid in PROD environments this is the reason I asked for any command line utility which does the same job.
Do you think doing these steps manually in PROD is preferred by PEGA?
@Asif_Hasan Thanks for the info but we already looked at this script it only provides cleaning for older rules from the rule tables in rule schema not deleting unused rule tables from data schema. For now we have to do the manual steps for PROD i guess. Thanks for your help.