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
  • Yes, I'd love that, Gawain!
    Thanks,

    Monica



    On Dec 31, 2014, at 11:16 AM, Gawain Lavers <bounce-gawainlavers9512@tessituranetwork.com> wrote:

    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!
Reply
  • Yes, I'd love that, Gawain!
    Thanks,

    Monica



    On Dec 31, 2014, at 11:16 AM, Gawain Lavers <bounce-gawainlavers9512@tessituranetwork.com> wrote:

    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!
Children