Stripping non-essential customer data from non-production database

Happy Holidays, Tessitura community!

 

I wonder if there are any of you who have written anything that strips customer data (perhaps except for a specified list of customer data) when restoring to a non-production or development environment in order to save space and eliminate the risk of secure data being on a laptop or other environment that might leave your premises.  We’re still on version 11 & are looking at being able to quickly automate a new development environment and it would be faster and easier to install a smaller segment of customer data with all of the Ticketing setup and campaign setup left intact in order to develop against up-to-date setup.

 

Thank you in advance to anyone who might have built something that would help me accelerate our progress toward quickly replicating our live environment with most customer information stripped out. 

 

Sincerely,

Monica

 

Monica Martin

Database Administrator

Oregon Shakespeare Festival

541-482-2111 ext. 221

www.osfashland.org

 

Parents Reply Children
No Data