Looking for an upgrade tool othe than the sql upgrade advisor

• cmrhema

  SSCommitted

  Points: 1558

  More actions

  May 26, 2012 at 11:31 pm

  #256599

  Hi,

  We are supposed to update our db from sql 2005 to sql 2008 r2 edition.

  We have used sql upgrade advisory tool.

  Can anyone suggest any other tool besides that.

  Regards

  cmrhema

• Jesse Reich

  Hall of Fame

  Points: 3020

  More actions

  May 27, 2012 at 12:14 am

  #1493571

  Have you read through the SQL Server 2008 Upgrade Technical Reference Guide?

  This includes multiple strategies for your upgrade as well as other utilities which can be used in addition to the Upgrade Advisor including:

  •SQL Server 2008 Upgrade Assistant

  •Best Practices Analyzer

  •System Configuration Checker

  •SQL Server Profiler

  •SQL Server: Deprecated Features Object Counter

  •More...

  Link: http://www.microsoft.com/en-us/download/details.aspx?id=15220