Home Forums Article Discussions Article Discussions by Author Discuss content posted by Bill Richards Database Server Upgrades – The Plan, The Template, and The Task List RE: Database Server Upgrades – The Plan, The Template, and The Task List

  • February 24, 2014 at 10:20 am

    #1691647

    DTS Packages

    Identify all packages to migrate

    Manually "Save As" packages to NEW server

    Update any affected pointers

    Scheduled Jobs

    Identify all Jobs to be migrated

    Copy jobs to New Server

    DO NOT COPY JOBS THAT RUN DTS PACKAGES. Reshedule packages instead

    Update any affected pointers

    Sorry for digging up an old thread but can I ask why it is necessary to reschedule DTS package jobs rather than run the scripted job on new migration instance?

    Thanks

    qh

    [font="Tahoma"]Who looks outside, dreams; who looks inside, awakes. – Carl Jung.[/font]