March 26, 2010 at 11:20 am
Hi,
I'm in a process of Upgrading SQL Server 2005 to 2008 using side by side upgrade method. We have more than 100 SQL Agent jobs which need to be migrated to new sql server 2008 instance.
I'm looking for an option of generating the scripts for all jobs in SQL Server 2005 and then run that generated script in sql server 2008. (I'm able to script one job at a time but want to script all jobs in one shot). Is that possible or I need script one by one and then execute in SQL Server 2008?
please advice
March 26, 2010 at 12:33 pm
I do not beleive you can script out all jobs at once. you can of course right click on each job and click script individualy but in your case I would recommend using SSIS. in SSIS you can creat a package quite easily to trasfer jobs. In the toolbox under control flow items there is a Transfer Jobs Task. I beleive this would handle moving all of your jobs in a few steps.
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
March 26, 2010 at 12:35 pm
As an added note I would create the SSIS on the 2008 server I am not sure if there would be any compatibility issues but by creating the SSIS on 2008 and bringing them over from there that should remove those problems.
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
March 26, 2010 at 1:39 pm
all jobs can be scripted from SSMS in one go.
double click on jobs under SQLAgent so the jobs appear in the right hand detail pane. Highlight all jobs (shift/click), then right click and select script job as.............
---------------------------------------------------------------------
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply