Endur/Findur - Post Refresh Updates

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!