SQL Server Standard Edition to Enterprise Edition
Another common query – How can I upgrade from SQL Server Standard Edition to Enterprise Edition
Use the following command to upgrade to a different edition of SQL 2005.
Go to Command prompt
“start /wait setup.exe ADDLOCAL=SQL_Engine INSTANCENAME=<Instance Name> UPGRADE=SQL_Engine SKUUPGRADE=1”
For complete details on command line based install refer to http://msdn2.microsoft.com/en-us/library/ms144259.aspx
Quick Note
1. Make sure you have the SQL Server 2005 Enterprise Media location in the setup.exe
2. After upgrading to SQL Server 2005 from another edition of SQL Server 2005, you must re-apply any hot fix or service pack updates to the upgraded SQL Server instance as Setup will remove all hotfix and service pack updates from the SQL Server instance being upgraded.
