In Dev, when we need to expose a column, we right click the property using property optimize tool to create new Database columns and populating the columns with values from blob, usually this is less than 5 minutes work.
Due to the production level setting, this option is not available in production. Seems the only way left is to run SQL in database to create the table columns(s), and run the command line column populate tool to populate the newly created column(s).
Due to the process overhead and production system accessibility, this approach is way more time consuming than the property optimization wizard.
Is it still advisable to directly run the property optimization wizard in production, or do we have any best practice how to deploy the property optimization result into production ?
The best practice , is to run the propertyOptimization wizard in development, and then import into production , and then run the prpcutils.bat to populate data. (by navigating to utils folder and run the command prpcUtils.bat expose).
It is a tool that you would run yourself. Instead of using a database connection like prpcUtils (and which you will not have details of since you are running on the cloud) the prpcServiceUtils is a rest service. You need the url of your system and an pega operator credentials to use it. On the PDN -> Resources -> PegaExchange and then search for prpcServiceUtils to find the tool to download.