I would like to occasionally take my Production database and restore it to the Development server to ensure that any tests performed are on a solid duplicate of the Production system.
We have distinct mailboxes available for both Production and Development.
I was wondering if anyone has developed any scripts, either automated SQL or simple manual checklists to ensure that email addresses are changed everywhere (mail settings, templates, open cases, etc.)?
Any other items that you are changing everytime you refresh Development with the Production data?
I just need to ensure that the Development system isn't sending messages to end-users and causing confusion.