Question
SQL script needed when property exposed?
Around 10 properties are exposed which mean respective DB table columns created in Dev DB. Now when I deploy this product in to QA should I write Alter table scripts for this 10 properties to effect of expose? I think there should be other way around like save class instances or DB-Table-Admin ... please advice
Hi,
Thanks, I am not clear, you want me to add Data-Admin-DB-Table in product rule "Individual instances to include" or where should I add this class?
Accepted Solution
Yes. Something like this. The property that has been exposed is defined on BHOO-BHOOTAPP-WORK so you can include the DATA-ADMIN-DB-TABLE record for this class.
I think you can run db scripts(to expose columns, create table etc.) automatically during pega code deployment only if your system's Production Level is <= 2. There is some DSS which can be set true or false which will decide whether you can even expose in systems with production level<=2.
I think this is a good strategy by design as most of the organization's DBA team would not want any DDLs to be executed automatically for audit reasons in higher environments. So from my experience it is always advisable to create separate scripts for DB changes and get them executed through DBA team.
Adding the Data-Admin-DB-Table instance to your Rule-Admin-Product instance when moving it from Dev to QA
https://pdn.pega.com/sites/pdn.pega.com/files/help_v719/procomhelpmain.htm#rule-/rule-admin-/rule-admin-product/contents.htm