Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Migration - SQL 2000 to SQL 2008 Expand / Collapse
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: Tuesday, March 24, 2015 6:44 AM
Points: 3, Visits: 142

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



Group: General Forum Members
Last Login: Thursday, December 8, 2016 1:32 PM
Points: 2,323, Visits: 2,261
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.

Post #1373824
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse