Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Migration - SQL 2000 to SQL 2008 Expand / Collapse
Author
Message
Posted Wednesday, October 17, 2012 7:00 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 4:57 AM
Points: 3, Visits: 138
Hi,

I need to migrate SQL 2000 to SQL 2008.
The path I want to take is backup SQL 2000 and restore to SQL 2008 compatibility mode 80. Then run the Microsoft SQL Server 2008 Upgrade Advisor to check for any issues.
But when I do this I get following error
"SQL Server version: 10.00.5500 is not supported by this release of Upgrade Advisor, only SQL 2000 or SQL 2005 is supported.

I need help with this issue as I cannot restore the 2008 data base in compatibility mode 80 on to 2000 and run the upgrade advisor.
Post #1373770
Posted Wednesday, October 17, 2012 8:20 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, September 5, 2014 9:04 AM
Points: 2,184, Visits: 1,976
From the download page for upgrade advisor "Upgrade Advisor analyzes instances of SQL Server 2000 and SQL Server 2005 to help you prepare for upgrades to SQL Server 2008." This means you run upgrade advisor BEFORE upgrading to see what issue might arise. You have already upgraded your database. You may be running it in compatibility mode 80 but the database has still been upgraded already. If you still have a copy on your SQL 2000 instance run the upgrade advisor there.




Francis
Post #1373824
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse