|
Posted by Tony Sebion on 09/30/05 19:15
You can copy DTS packages by opening up the current package and choosing
"Package/Save As..." from the menu bar. Be careful to make sure your
database references within the DTS package are still appropriate on the
new server.
Both jobs and alerts can be scripted and that script executed on the new
server - right click the jobs or alerts and choose "All Tasks/Generate
SQL Script...". More than one job or alert can be selected at a time if
you desire.
Good luck,
Tony Sebion
"Laurence Breeze" <i.l.breeze@open.ac.uk> wrote in message
news:433D4E58.2050802@open.ac.uk:
> I want to copy a database from one server to another. I'm happy about
> how to do this but also want to copy a number of DTS packages, jobs and
> alerts that relate to this database. Is there any way that I can copy
> them or will I need to create them again on the new server.
>
> Many Thanks
>
> Laurence Breeze
Navigation:
[Reply to this message]
|