August 8, 2007 at 8:21 am
Can we run upgrade advisor on SQL 2005 server?
August 8, 2007 at 8:27 am
Are you talking about upgrading SQL 2005 to, say, the 2008 beta or something?
August 9, 2007 at 12:26 am
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
August 9, 2007 at 3:08 am
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
August 10, 2007 at 12:08 pm
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