Stripping non-essential customer data from non-production database

Hi Monica,

I'm actually currently in the process of reviewing an old routine that we used for this in v10, which I need to upgrade for our current system (v12.1).  If such a thing would be helpful at all (currently just have the v10 version) I can pass it along.

 

--Gawain

From: Monica Martin <bounce-monicamartin8067@tessituranetwork.com>
Sent: 12/30/2014 11:43:37 PM

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

 

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

This e-mail message is intended only for the recipient(s) named above. This message may contain trade secrets, attorney-client communication, or other privileged and confidential information. Any review, re-transmission, dissemination, reproduction or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the Sender and delete the material from any computer.

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!