One customer has some specific updates that need to be made after a refresh of their Endur/Findur database from Production.
We developed a custom script for this which allows them to add to / amend where necessary.
The script follows the following basic steps:
- Derive required configuration from an emdash Environment Wide Setting / Env Wide Setting Option.
- This includes getting the logic on whether to apply an update (with a Boolean setting) as well as the desired value for the target environment
- Define a SQL Statement to update the data as required
- Loop through all SQL Statements, logging out error for any statement that fails.
Feel free to use this as a template and update as you need!