Migration from SQL 2005 to SQL 2008

• VSSGeorge

  SSCrazy Eights

  Points: 8146

  More actions

  September 10, 2012 at 12:26 am

  #281412

  Hi

  My friend wants to migrate his database in SQL 2005 to SQL 2008.He has some SSIS packages running on his SQL 2005 database.

  a)How will these packages be affected by changing the database version to 2008.

  b)What else needs to be considered for migration of stored procedures & other DB objects in 2005 to 2008?

  Any help is very much grateful.

• VSSGeorge

  SSCrazy Eights

  Points: 8146

  More actions

  September 10, 2012 at 3:43 am

  #1535583

  Hi friends, pls comment on my query and help me out..

• Ant-Green

  SSC Guru

  Points: 113445

  More actions

  September 10, 2012 at 3:45 am

  #1535584

  Run the upgrade advisor for 2008, also test all packages work in their 2005 format, otherwise upgrade them in BIDS 2008, test and redeploy.

  The upgrade advisor will tell you if it sees any problems in upgrading from 2005 to 2008 and then you can take the nessesary action.