pre- and post-section for queries/scripts (datamanipulation) within your Deployment

By Hans Dollen on 15 Nov 2013
I currently have a little problem, I've added a unique key to a table, but the values aren't yet unique. 
So, In fact I want to add an SQL script, are advanced query which must be add to the deployment. When I use lifetime, the script must be executed automatically as first step of the deployment. 

And perhaps you want to select if the query must be executed as first or as the last step of the deployment.


Justin James18 Nov 2013
You can make a timer to be set to run "When Published" which accomplishes a lot of what you are looking for, at least in terms of executing a query (or any other code) after deployment is done.

J.Ja
Hans Dollen18 Nov (2 weeks ago)

Hi Justin, 

sometimes, we need to run a script before the deployment will be executed. E.g. when you want to convert the type of an attribute from text to integer, or when you have to update a status, because that status-value is going to be removed. 

Hans