Post reply

Migrate jobs from 2000 to 2008

  • February 12, 2013 at 1:14 am

    #274045

    Hi All,

    I need your advice to process migrate the SQL SERVER AGENT JOBS from 2000 to 2008. Please advice me which is the best way and how do i do?

    Thanks in advance

    Satish

  • February 12, 2013 at 8:29 am

    #1587046

    Hi,

    Use management studio (2008), connect to your 2000 instance, expand sql agent, right click on a job, Script job as>Create to> File or new query editor window.

    Use the generated code and run it on your SQL 2008 and the job is created.

    If you have thousands of jobs maybe this isn't the best solution.

  • February 12, 2013 at 3:14 pm

    #1587222

    If you have thousands of jobs just click on the Jobs node in Object Explorer and press F7 to open the Object Explorer Details. Then highlight all the jobs you want to script, right-click and script the jobs to a single query window or file.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

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

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