Upgrade existing sql 2000 enterprise to 2005 standard

[Luvsql]

We purchased SQL 2005 Standard as many of our reasons for purchasing 2000 Enterprise are now available in Standard (plus saved thousands of dollars). I ran the upgrade advisor with no issue, but when I went to upgrade, it says it's blocked because of Version issues.

I really do not want to have to install a named instance of 20005, then detach/attach into 2005, copy logins, etc as it's a pain AND I have to reconfigure all our apps to the nameed instance plus then have 2 versions running on the server.

I would like to upgrade to 2005 Standard. Is the only workaround to uninstall 2000 EE then reintall 2000 Standard, get that working THEN upgrade to 2005?

It was Microsoft's idea to "upgrade" the functionality in the Standard edition so why can we not upgrade since we purchased it?

 

[Jamfool]

Did you use the SKUUPGRADE flag when running the setup?

SKUUPGRADE=1

http://msdn2.microsoft.com/en-us/library/ms144259.aspx

 

[Luvsql]

This is SQL 2005. Is that still an option?

 

[Jamfool]

yes it still applies.

 

[mrdenny]

Correct you have to install SQL 2000 EE and install SE in order to upgrade to SQL 2005 SE.

Most features are moved from the higher cost SKUs into the lower cost SKUs after a version or two so that those features get a higher market penetration. Also after that time there are new features which are included in the EE that aren't in the SE which will drive sales as these older features are no longer considered to be sales drivers.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog