Our current process of doing production database refreshes is to turn off the appropriate business rules that involve sending out emails or texts to users in the field. Then, set the phone number and email address fields to NULL via a SQL update.
We want to keep all business rules active and contact information intact, but would like to have something that does not send out communications when testing the business rules in our pre-production environments if we need to fix or change them.
Does anyone have any ideas on to make this process easier and reduce the time to refresh production data into pre-production environments?