**self-hosted*
Can anyone share with me their process for automating the LIVE to TEST copy?
Right now I have a checklist that I follow to do it manually. Basically I stop the TessService app pool, then blow away the impresario database on our TEST server (right click --> delete). I then execute a database restore using the most recent back up. After that I recreate the logins and then run a series of queries (in a specific order) to do things like change the dbo owner, update defaults, etc.
I do this once a month right now. If I could automate the process I would like to see it occur more often (one a week maybe).
Anybody have any thoughts???
Ashley Elliott
Database Administrator
St. Louis Symphony Orchestra
314-286-4198
ashleye@slso.org
I'm sure someone will chime in with a script for doing the actual copy (we're on RAMP so I don't have that), but I do have a fairly involved script for update Tessitura configuration after copy completion, if you're interested in seeing that.
Gawain Lavers
That would be interesting. Thank you for the willingness to share.