Question

5
Replies
1615
Views
Close popover
Tom Zhang (ZHANQ)
PEGA
Principal System Architect
Pegasystems
CA
ZHANQ Member since 2007 5 posts
PEGA
Posted: January 24, 2017
Last activity: February 22, 2017
Closed
Solved

How to deploy property optimization result to production

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 ?

Thanks

Tom

***Moderator Edit: Vidyaranjan | Updated Categories***

Data Integration
Moderation Team has archived post