SQL 2000 to SQL 2008 upgrade problem - FeatureUpgradeMatrixCheck

[djj55]

Hello, when trying to do an upgrade from 2000 to 2008 everything works up to the Upgrade Rules check.

The problem comes on FeatureUpgradeMatrixCheck which Checks whether the specified feature meets SQL Server 2008 upgrade requirements this fails and suggests: The specified edition upgrade is not supported. For information about supported upgrade paths, see the SQL Server 2008 version and edition upgrade matrix in Books Online.

Having been through the list several times I cannot find any mismatch.
SQL 2000 Enterprise SP4 on Windows 2003 R2 Enterprise SP2, Intel Pentium III, 2GB RAM, 50+G free space
going to:
SQL 2008 Standard

Note that this is just a trial system before updating on our production system that has much better specifications.

Have I missed anything?

Thanks

djj
The Lord is My Shepard (Psalm 23) - I need someone to lead me!

 

[gmmastros]

My take on this...

The specified [!]edition[/!] upgrade is not supported.

SQL 2000 [!]Enterprise[/!] SP4
SQL 2008 [!]Standard[/!]

There are features available with Enterprise that are not available with standard. If I am not mistaken, you cannot upgrade a SQL instance from Enterprise to Standard because that would actually represent a downgrade. From the sounds of it, you will actually be replacing the server, which probably means a fresh install of SQL2008. To migrate, you will probably backup/restore or detach/attach. So you will probably NOT be upgrading an existing SQL instance.

But... You should double and triple check your database usage. If you are using any of the enterprise features from SQL2000, then you may want to re-think your version of sql2008.

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[gmmastros]

Oh yeah... one more thing. Don't just take my word on this. You should do a lot more research on this before deciding on anything. The last thing you want to have happen is a failed upgrade.

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[djj55]

Two managers and myself have been through the features we currently use and are planning on using. The decision was made to go with 2008 Standard. We are not using most of the features in the current Enterprise as the people who bought it were not DBAs. (example: the upgrade from Access made zip code a float)

Thank you for the catch.


djj
The Lord is My Shepard (Psalm 23) - I need someone to lead me!