Home Forums SQL Server 2005 SQL Server 2005 General Discussion Tool to analyze database before changing compatibility level 80 to 90 in SQL Server 2005 RE: Tool to analyze database before changing compatibility level 80 to 90 in SQL Server 2005

  • 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