Discussion
Accenture Services Pvt Ltd
IN
Last activity: 6 Apr 2018 19:26 EDT
Upgrade PRPC6.3 to PRPC 7.1.8
We are upgrading PRPC6.3 to PRPC 7.1.8 from single schema to split schema process. After upgrading the old dataschema to 7.1.8 there is one process mentioned in 7.1.8 upgrade document " cleaning up unused tables". From Optimizing Schema option we have to select the Data schema to delete the unused Rules schema from the old schema. Now if we want to run that clanup manually, how can we generate the script with all unused tables to be dropped?
Please suggest.
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
NIIT Technologies Limited
AU
I guess optimize schema wizard doesn't support generate and download script options.
So you have to write queries to delete the unused tables manually.
Pegasystems Inc.
IN
As of now there is no OOTB way to generate the unused tables script, you have to manually identiy all the table lists from Optimize schema wizard for both Rules and Data schema then write SQL queries to drop those tables from respective schemas.
Thanks,
Dhev
Areteans Technology
IN
Have to do a one time activity of finding the unused tables in one environment(dev) and then run the queries in other environments. Bit manual excercise. An OOTB script should have been better.
Thanks,
Ashok