check list for Migrating sql server 2000 to 2008

• patwarimk

  SSC Journeyman

  Points: 76

  More actions

  February 23, 2010 at 10:23 am

  #219434

  Hello,

  Iam new to database testing and We are migrating database from SQL 2000 to SQL 2008 . Please any one can give me the information what we need to test while migrating SQL 2000 to SQL 2008 in testing aspect.

  Thanks!

• Vinay Thankur

  SSCarpal Tunnel

  Points: 4178

  More actions

  February 23, 2010 at 11:33 am

  #1123784

  Please check.

  http://blogs.msdn.com/chkoenig/archive/2008/12/01/upgrading-from-sql-2000-2005-to-2008.aspx

  also video:

  http://blogs.msdn.com/chkoenig/archive/2008/12/01/upgrading-from-sql-2000-2005-to-2008.aspx

  HTH

  Vinay

  Thanx.
  Vinay

  http://rdbmsexperts.com/Blogs/
  http://vinay-thakur.spaces.live.com/
  http://twitter.com/ThakurVinay

• Steve Jones - SSC Editor

  SSC Guru

  Points: 739578

  More actions

  February 23, 2010 at 4:05 pm

  #1123955

  Run the upgrade advisor to see what pops up.

  I would also run a profiler trace of a test upgrade and look for deprecated code. There's an event for that. (http://www.mssqltips.com/tip.asp?tip=1370)