Upgrade advisor on sql2005?

  • Can we run upgrade advisor on SQL 2005 server?

  • Are you talking about upgrading SQL 2005 to, say, the 2008 beta or something?

  • no upgrading to sql 2005, i mean if i restore the DB of sql 2000 on sql 2005 and then run upgrade advisor on sql 2005..

    it seems to me i cannot run the warrning i get

    "SQL Server version: 09.00.1399 is not supported by this release of Upgrade Advisor"

    just wanna confirm

  • You are right, you cannot run the Upgrade Advisor for SQL Server 2005 on SQL Server 2005, even if the databases you want to check are in compatibility mode 70 or 80. You will need to restore the database in question on a 2000 server.

    Andras


    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software

  • More simply, you need to use the Upgrade Advisor by running it against the 'before' environment. Loading the database into SS 2k5 is placing the content into the 'after' environment - something you should only be doing AFTER you've run the UA.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply