I seem to recall at a conference one time someone presented a script that essentially made the dreaded LIVE to TEST copy an SQL Server Agent Job that you could schedule whenever you liked (like in the middle of the night when no one else would be using the system) and not be stuck up at the office for two hours. Perhaps it was one of those Mini-Magic solutions?
Does anyone recall that, and if so, can they direct me to such precious materials? Our network administrator used to perform LIVE-to-TEST copies and she recently passed away suddenly. With rollovers coming shortly, I'd love to be able to get this solution up and running in time.
Thank you in advance, as always, Tessiturians.
Literally just yesterday I finished rewriting our live-to-test copy into a single PowerShell script. It's not super-portable yet, but it's on its way and could be modified to suit a different environment without too much difficulty.
If you can't find an existing ready-made one, I'm happy to share my work on Bitbucket as a starting point -- maybe we could build on it collaboratively.
That sounds glorious. I've only had to do it a few times so far, but I already dislike it. I'd saved the post copy cleanup stuff as sql queries and was going to build them as a job that I could schedule. Having the rest of the copy process available like that would be extremely helpful.