Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Transfering
Message
From
14/06/2002 11:03:04
 
General information
Forum:
Microsoft SQL Server
Category:
Database management
Title:
Miscellaneous
Thread ID:
00668453
Message ID:
00668554
Views:
11
>Hi All:
> How can I copy jobs and local packages from a database that is in Server ONE to a database that is in Server TWO?
>
>I was able to transfer tables,SP and views using DTS, however I am not able to copy jobs or packages using DTS.
>
>Thanks
>MA

As Sergey suggested on the VFP forum, you can script the jobs in one server and run them on the new to create. For DTS packages go to www.sqldts.com and download (free) DTSBackup 2000. HTH
Previous
Reply
Map
View

Click here to load this message in the networking platform