Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Database Server Upgrades – The Plan, The Template, and The Task List Expand / Collapse
Author
Message
Posted Sunday, May 10, 2009 10:40 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Monday, November 24, 2014 8:40 AM
Points: 3,244, Visits: 5,008
Very useful information.
Thanks.


----------------------------------------------------------------------------------------------------------------------------------------------------------------------

Sometimes, winning is not an issue but trying.

You can check my BLOG here

Post #713839
Posted Thursday, February 21, 2013 10:43 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, February 22, 2013 5:57 AM
Points: 2, Visits: 7
I am not sure if I can use the same plan. But, I am looking for upgrade plan that occured twice a year. Once in April and the other in October. I am looking for a template to have high level milestones and the same template will be used for future upgrade.... Please HELP
Post #1422716
Posted Monday, February 24, 2014 10:20 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 4:42 AM
Points: 2,451, Visits: 1,038

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


SQL 2K acts like a spoilt child - you need to coax it round with lollipops.
Post #1544632
Posted Tuesday, February 25, 2014 7:30 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Saturday, July 12, 2014 6:44 AM
Points: 441, Visits: 1,799
when you upload a DTS package, it gets given a GUID. The jobs refer to this GUID, which will be different on the new server, as it is a 'new' package. one workaround is to edit the job to refer to the dts name instead of Id, but I think it is easier to re-schedule

HTH

Dave Jackson



http://glossopian.co.uk/
"I don't know what I don't know."
Post #1544910
Posted Tuesday, February 25, 2014 1:47 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 4:42 AM
Points: 2,451, Visits: 1,038
Cheers David!

Rgds,

qh


SQL 2K acts like a spoilt child - you need to coax it round with lollipops.
Post #1545130
Posted Tuesday, June 10, 2014 3:48 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, July 7, 2014 2:53 PM
Points: 1, Visits: 16
Hi,

How long does it usually take for an upgrade to be completed? Thanks!
Post #1579431
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse