Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Sqlbuddy
Starting Member
27 Posts |
 Posted - 2009-05-12 : 18:18:04
|
| Hi, Could anyone tell me how to migrate the jobs from SQL Server 2000 to SQL Server 2005?Can we script the jobs from SQL Server 2000 using SSMS and then execute them on the SS2005 instance? Are there any caveats in this approach. Thank you,YoursSQL Buddy |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-05-12 : 18:48:51
|
| The SSIS Transfer Jobs Task will do the actual transfer, it doesn't appear to save the jobs to scripts however. You can also right-click each job in Management Studio and choose Script Job, then run that script on the new server.Keep an eye out for any operators that receive job notifications, you may have to script them out separately and create them ahead of time. |
 |
|
|
Sqlbuddy
Starting Member
27 Posts |
Posted - 2009-05-13 : 10:10:11
|
| Hi Robvolk, Thank you very much! I really appreciate your help.Yours,SQLBuddy |
|
|
|
Sqlbuddy
Starting Member
27 Posts |
Posted - 2009-05-13 : 13:54:41
|
| Hi robvolk, I have found a better solution. To script all the jobs or alerts or operators in SQL Server 2000 instance, just open the Enterprise Manager and then Right click on jobs or alerts or operators and then select All tasks and Generate SQL script. All the jobs etc.. will be scripted to a single .sql file. We can then just execute the script on the SS2K5 instance. Thanks,Yours SQL Buddy |
|
|
|
|
|
|
Migrating jobs from SQL Server 2000 to SS2K5