Upgrade from SQL Server 2000 (2005) to 2008

• andegre

  SSCertifiable

  Points: 5875

  More actions

  January 27, 2010 at 9:09 am

  #218590

  Are there any tools out there that will analyze stored procedures, triggers, and functions to determine if they will behave the exact same way after upgrading to 2008 (or 2005 compatibility mode)?

  Thanks

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  January 27, 2010 at 9:16 am

  #1109371

  The upgrade advisor. Free download from MS. It probably won't pick up all the issues, but most.

  You'll still need to do careful testing...

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  January 27, 2010 at 9:17 am

  #1109373

  There's the SQL Server Upgrade Advisor, a free download from MS: http://www.microsoft.com/downloads/details.aspx?familyid=F5A6C5E9-4CD9-4E42-A21C-7291E7F0F852&displaylang=en. It will explain things that need to be changed before or after upgrading.

  Greg