Tool to analyze database before changing compatibility level 80 to 90 in SQL Server 2005

• scorpnit

  Old Hand

  Points: 369

  More actions

  November 14, 2014 at 1:48 am

  #147180

  Hello,

  Is anyone aware of any analyzer/ advisor tool that will help me generate a report of incompatible objects in SQL Server 2005 compatibility mode 80 before actually changing it to compatibility 90.

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  November 14, 2014 at 1:55 am

  #1758465

  There's a tool called "Upgrade Advisor" that does exactly this.

  See here for more information http://msdn.microsoft.com/en-us/library/ms144256.aspx

  However, I don't recommend switching to 2005. While you're at it, use a newer SQL Server version (if possible).

  -- Gianluca Sartori