May 1, 2008 at 7:11 am
We are suppose to be upgrading to SQL 2005 from 2000 very soon. Is there anyone who can advise me on how to move the jobs from 2000 to 2005?
I know if there are not many of them, it is better to recreate those jobs in 2005, but we have about 90 jobs. How to do this successfully?
Please help!
[font="Verdana"]Imagination is more important than knowledge-Albert Einstein[/font]
May 1, 2008 at 7:25 am
Click on the Jobs folder in SQL Server Management Studio. In the Object Explorer Details window, select all of the jobs. Right-click, and choose Script Job As -> Create To -> New Query window. Run the script on the new server. Beware of things that might fail on SQL 2005, such as non-ANSI outer joins. If you ran the Upgrade Advisor, then those things should already have been brought to your attention.
John
May 1, 2008 at 7:30 am
Thanks for your answer. Will this work out well( other than the outer joins issue)? Have you face any trouble after that? Like some jobs failing and all that?
Please guide me into this so that I can be very careful and safe.
Also, do you have any idea about the logins? Can I do the same to ensure success there as well?
[font="Verdana"]Imagination is more important than knowledge-Albert Einstein[/font]
May 1, 2008 at 7:36 am
The only way to know is to test it, I'm afraid. The outer join issue was just an example: there are many more pieces of code that work in 200 but fail in 2005.
I take it you're building a new server and then migrating the database rather than upgrading in place?For the logins, you can script them also. Beware of orphaned users in databases if you do this. There are DTS/SSIS tasks that will copy logins for you as well. Try both on a test server and see which one suits you better.
John
May 1, 2008 at 7:42 am
Well, actually it is a little bit more complicated than that. We are about to upgrade to 2005 BUT by uninstalling the 2000 in the same box using a detach/attach method.(don't ask me why they are going this way, i have done that part myself).
Any other inputs are most welcomed! Please give me more tips! Thanking all of you in advance.......
[font="Verdana"]Imagination is more important than knowledge-Albert Einstein[/font]
May 1, 2008 at 8:28 am
That's not the worst plan, although it things don't work you'll have an extended outage while you remove 2005 and reinstall 2000.
Be sure you keep backups of the 2000 databases handy. Once you attach the 2000 databases to 2005, they can't move back to 2000.
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply