• Replies 17 replies
  • Subscribers 340 subscribers
  • Views 316 views
  • Users 0 members are here
Related

Automating LIVE to TEST copies

Ashley Elliott (Past Member)
$organization

**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

Parents
  • $organization
    Nick,
     
    Thanks so much for sharing. I’ve been programming since 1997 and so I understand your trepidation with sharing code like this. I only want to study it to see how you are doing certain things. My programming experience is mostly .net and t-sql (with some dabbling in vba, javascript, php). Not much powershell. I think I’m missing out on a lot of “work smart not hard” opportunities that powershell provides.
     
    Thanks!
     
    Jerry Boutot | Manager, Information Technology - Data
    O: 813.222.1097 C: 352-428-4199
     
Reply
  • $organization
    Nick,
     
    Thanks so much for sharing. I’ve been programming since 1997 and so I understand your trepidation with sharing code like this. I only want to study it to see how you are doing certain things. My programming experience is mostly .net and t-sql (with some dabbling in vba, javascript, php). Not much powershell. I think I’m missing out on a lot of “work smart not hard” opportunities that powershell provides.
     
    Thanks!
     
    Jerry Boutot | Manager, Information Technology - Data
    O: 813.222.1097 C: 352-428-4199
     
Children
No Data