i have an entity and one attribute of integer data type. I will change it as an idenitifier (this is already done). But at the same time I need a way (from OS, not using SQL, neither sp) to erase all the values of such column and it should erase such values of that column for all environments (dev, qld, prd)... and just for once. How to achieve it? Thanks. 

In this situation I have used Timers that are set to trigger "When Published". 

This timer will loop through all your records clearing the value and saving the updated record.

A way to make this only loop once is by having an aggregate that has a filter that checks if that column has something different than null (IntColumn <> NullIdentifier()), and have an if afterwards checking if the Aggregate is empty, if it is it just ends.


Andres Moreno