Re: copying server objects

From: "Tony Sebion" <tony@xxxxxxxxxx>
Date: Fri, 30 Sep 2005 16:15:25 +0000

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@xxxxxxxxxx> wrote in message news:433D4E58.2050802@xxxxxxxxxx:

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

References:
- copying server objects
  - From: Laurence Breeze

Prev by Date: Re: Performance and second table
Next by Date: Re: How to save DTS package as an application
Previous by thread: copying server objects
Next by thread: Maintaining a chain with multiple inserts
Index(es):
- Date
- Thread