• Replies 11 replies
  • Subscribers 340 subscribers
  • Views 130 views
  • Users 0 members are here
Related

Automating LIVE to TEST DB Refresh?

Michael Johnson
$organization

Hi,

Does anyone have experience automating the Backup/Restore method of refreshing your TEST environment from LIVE? If so, could you provide some direction on how you did it? We're on v11.0.0.3 and SQL '08 R2 with separate PROD and TEST SQL servers.

We currently do it manually but our box office wants to increase the frequency of the refresh to weekly so we'd like to automate it as much as possible. Any guidance is appreciated.

Thanks, Michael J

Metropolitan Museum of Art

Parents
  • $organization

    We use the backup/restore method too and still do it manually.  Looks like it’s going to become a little more time consuming in v11!  So I’d be interested in automation ideas as well.

    Thanks,

    …Dave

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Michael Johnson
    Sent: Wednesday, December 05, 2012 8:57 AM
    To: Vivino, David
    Subject: [Tessitura Technical Forum] Automating LIVE to TEST DB Refresh?

     

    Hi,

    Does anyone have experience automating the Backup/Restore method of refreshing your TEST environment from LIVE? If so, could you provide some direction on how you did it? We're on v11.0.0.3 and SQL '08 R2 with separate PROD and TEST SQL servers.

    We currently do it manually but our box office wants to increase the frequency of the refresh to weekly so we'd like to automate it as much as possible. Any guidance is appreciated.

    Thanks, Michael J

    Metropolitan Museum of Art




    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
  • $organization

    We use the backup/restore method too and still do it manually.  Looks like it’s going to become a little more time consuming in v11!  So I’d be interested in automation ideas as well.

    Thanks,

    …Dave

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Michael Johnson
    Sent: Wednesday, December 05, 2012 8:57 AM
    To: Vivino, David
    Subject: [Tessitura Technical Forum] Automating LIVE to TEST DB Refresh?

     

    Hi,

    Does anyone have experience automating the Backup/Restore method of refreshing your TEST environment from LIVE? If so, could you provide some direction on how you did it? We're on v11.0.0.3 and SQL '08 R2 with separate PROD and TEST SQL servers.

    We currently do it manually but our box office wants to increase the frequency of the refresh to weekly so we'd like to automate it as much as possible. Any guidance is appreciated.

    Thanks, Michael J

    Metropolitan Museum of Art




    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
No Data