July 24, 2002 at 3:25 pm
I have read the numerous articles on how to move a database from one server to another (via detach/attach). However, how do I...
1. Programmatically identify and move the user's stored procedures, logins and error message in the master database?
2. Programmatically identify and move users jobs that are in MSDB?
Any guidance or help would be appreciated.
Thanks,
Patrick
July 24, 2002 at 3:48 pm
DMO might be the best way. There are articles on moving logins (and passwords), but there is also a DTS task to do this. To move the master stored procedures, there's a DTS task as well. Errors? Not sure. I'd probably develop a custom DTS task to do this.
Steve Jones
July 24, 2002 at 8:06 pm
Agree that if you can do it with DTS thats the easiest way. If you're moving all the jobs you could look at moving the MSDB itself to the other server. If not, then even once you figure out which are "user" procs/jobs/etc, still have to determine which ones really need to be copied or are really unrelated.
Andy
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply