**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
As you all know, I'm ideologically opposed to sharing code out of band of network collaboration tools and am contractually obligated (jk) to shill Bitbucket whenever possible. (The real reason is so people searching this thread in the future can still access the content without emailing me.) Please enjoy this snippet on Bitbucket:
https://bitbucket.org/TN_WebShare/workspace/snippets/bxL697/db-copy-scripts
You will need Bitbucket access in order to view -- see Tom Brown's post from a few days ago in this same topic for directions if you are unfamiliar.
Also: this is HEAVILY caveated as being highly org-specific and also minimum-effort. There are hardcoded secrets/tokens which have been replaced by benign text. There are plenty of opportunities for making a more robust system out of it, but I think the concepts at play here are useful to wrap your head around and can be easily applied to your own systems.
My only other ask is that you please do ask for clarifications using the comment thread at the bottom of the snippet. The WTFs per Line of Code is definitely not zero.
CC Jerry BoutotJo BramleyAshley Elliott (Past Member)