December 23, 2008 at 3:45 am
I have been asked about upgrading from an existing developer edition install which has gone into production to enterprise edition.
I'm wondering if anyone has any experience of performing an in place upgrade - as far as I can tell from searching online we should just be able to run the enterprise edition setup and the process should identify for itself what to do.
Obviously a full backup of the databases and the system is desirable before hand but can anyone advise if this is the correct approach or for any pitfalls to be aware of before proceeding.
Many thanks
December 23, 2008 at 4:26 am
Setup will upgrade only from lowever version to higher version (e.g. SQL Server 2000 to 2005).
To upgrade only the edition, you should run following command:
start /wait setup.exe ADDLOCAL=SQL_Engine INSTANCENAME=MSSQLSERVER UPGRADE=SQL_Engine SKUUPGRADE=1 /qb
In adition to taking full backup, run DBCC CHECKDB.
There are no pitfalls as such. Everything should be fine.
December 23, 2008 at 4:58 am
Thank you
January 8, 2009 at 10:04 am
Just for completeness and to save time for anyone else trying to figure out how to upgrade from developer edition to enterprise edition we have now tested the upgrade process and have successfully used the following :
start /wait SKUUPGRADE=1 ADDLOCAL=SQL_Engine INSTANCENAME=MSSQLSERVER UPGRADE=SQL_Engine
I would assume if you have a separately quoted PID key you will need to add that as well.
We did have to reinstall service packs after running the process but that was expected.
The MSDN article on how to install from the command prompt is useful but it's a pain finding all the information you need in one place :
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply