Upgrading msdb and dts packages from sql 2000

• Nikita-395727

  SSC Eights!

  Points: 898

  More actions

  January 15, 2007 at 2:36 pm

  #174562

  Hi,

  We have installed sql server 2005 on the different server than our 2000 server. Detaching/Attaching data files works very well for upgrading user databases. What is the best way to upgrade msdb and DTS packages on the new 2005 server?

  Thanks

• MohammedU

  SSCoach

  Points: 19644

  More actions

  January 15, 2007 at 3:17 pm

  #683367

  You can move system databases from 2000 to 2005 where as you can script the jobs and dts packages can be move using migration wizard...

   

  SQL Server 2005 Books Online 

  Using the Package Migration Wizard 

  http://msdn2.microsoft.com/en-us/library/ms143496.aspx

   

  MohammedU
  Microsoft SQL Server MVP