SQL 2005 Developer to SQL 2005 Standard

jperry933 · 05-06-2009, 07:34 PM

Has anyone done this? We have a server that has Developer installed and we now want to upgrade to Standard, but don't want to do a full re-install. I know there is a direct upgrade path between the two versions and that you can run setup from the command line and use the SKUUPGRADE=1 option to switch between versions. Has anyone done this before?
setup.exe ADDLOCAL=SQL_Engine INSTANCENAME=MSSQLSERVER UPGRADE=SQL_Engine SKUUPGRADE=1 /qb

TRYDL · 05-07-2009, 09:46 PM

Funny how developer edition really as the EE engine and yet it is being upgraded to standard

At any rate since you are updating the engine, everything else should be ok if left as is.

I'm sure you already saw this link, but I'll add it for others.
Version and Edition Upgrades

I would doublecheck the upgrade of Developer to Standard just incase SSRS and SSAS complain during the upgrade.

Just my $0.02