March 22, 2012 at 9:11 am
I have to manage 100s databases, and update SPs, UDFs, and Functions periodically, and I do them all manually. How to automate these steps? Instead of doing them manually, I want to do it programmatically. Pl help and thanks in advance.
For example: I have a proc in a Folder, and I want to update it to server instance SQLABCD. I want to back up the proc also before update.
March 22, 2012 at 10:17 am
Joe-420121 (3/22/2012)
I have to manage 100s databases, and update SPs, UDFs, and Functions periodically, and I do them all manually. How to automate these steps? Instead of doing them manually, I want to do it programmatically. Pl help and thanks in advance.For example: I have a proc in a Folder, and I want to update it to server instance SQLABCD. I want to back up the proc also before update.
redgate SQL Multi Script 1.1[/url] does this.
As for backing up the object before deployment I am not sure if Multi Script will do that. That requirement poses many challenges in knowing which objects to backup, do you key off the file name to know the object name? do you have to read into the file looking for DROP or ALTER statements? ...if backing up the objects before deployment is a hard requirement you may want to look into rolling your own solution with PowerShell.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply