Post reply

Upgrading Jobs from 2000 to 2005

  • April 4, 2006 at 12:47 pm

    #171156

    Has anyone attempted to upgrade jobs in sql 2000 to sql 2005?  Or should I just recreate them?

    Thanks for your help in advance.

    Mike

  • April 4, 2006 at 2:10 pm

    #630821

    Michael,

    you can not just re-create, I assume. Jobs are different, some run Maintenance Plans, some run DTS packages. For the miantenance Plan we found out that "Delete Files Older Than .... days" feature to delete old backup and log files is moved to the separate Package Task named Maintenance Cleanup Task. For your SQL jobs see if there is no obsolete statements. I would advise to try on the test server first and see if all features of your jobs are working.

    Regards,Yelena Varsha

  • April 5, 2006 at 6:00 am

    #630942

    Mike,

    I would advice you to use SQL Server Upgrade Advisor. This can be downloaded from http://www.microsoft.com/downloads/details.aspx?familyid=6107C27A-662C-4319-AFE7-B52D1568C30A&displaylang=en

     






    Regards,
    Sudheer 

    My Blog

  • April 5, 2006 at 11:08 am

    #631059

    It looks like you can perform the following steps to migrate your jobs to a new 2005 server:

    1. Script the job as create
    2. Modify the script with the new server settings
    3. Run the script on the new server

    Thanks for everyone's help!

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply