July 15, 2008 at 10:42 am
Is there anyway to run the SQL Server 2005 Upgrade Advisor vs a SQL 2005 Server that houses SQL Server 2000 (8.0 Compatibility Mode) databases?
I understand that Upgrade Advisor sees this as a 2005 server but if there are databases on there that are in 8.0 compatibility mode it would be useful to run upgrade advisor against those databases to determine the amount of intervention required in order to get the database(s) to full 9.0 compatibility mode.
Thanks
July 15, 2008 at 11:36 am
Maybe you could copy the databases to an instance of SQL 2000 and run it on there?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
July 15, 2008 at 12:52 pm
you can't restore a 2005 database (even in 8.0 compatibility mode) to a 2000 instance.
July 15, 2008 at 2:15 pm
I could be mistaken, but all you need to check for compatibility is usually the structure and code. So, run Tasks\Generate Scripts... on the database. Script all tables, procs, etc. Select the option that allows you to have the scripts created for SQL 2000. Include Create Database in the scripts.
Connect to an SQL 2000 server, run the scripts. Run the upgrade wizard.
Will that not give you what you need?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
July 15, 2008 at 2:17 pm
yeah that has been my fall back plan but was hoping that I was missing something to get Upgrade Advisor to work.
Thanks for the replies!!
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply