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 ?
***Moderator Edit: Vidyaranjan | Updated Categories***