Can SQL 2005 32bit Standard edition be upgraded to SQL 2005 32bit Enterprise Edition in-place.
Can SQL 2005 32bit Standard edition be upgraded to SQL 2005 32bit Enterprise Edition in-place.
Andy,
Yes SQL Server 2005 Standard can be upgraded to SQL Server 2005 Enterprise. Remember after the upgrade you will need to reapply any hot fixes and service packs.
http://msdn2.microsoft.com/en-us/library/ms143393.aspx
Hope this helps
Michael
Michael,
Just one more question, Can this be done by just executing the setup.exe on the cd and selecting the instance I want to upgrade correct
Andy
Andy,
Make sure that you select that you want to upgrade and not install a new/named instance.
Hope this helps
Michael
use SKUUPGRADE=1 swtich from the command prompt with setup.
Eg :
start /wait setup.exe ADDLOCAL=SQL_Engine INSTANCENAME=MSSQLSERVER UPGRADE=SQL_Engine SKUUPGRADE=1 /qb
Refer
http://msdn2.microsoft.com/en-us/library/ms144259.aspx#skuupgrade
Madhu
OK, I am little confused, I have two separate answers. One answer says I can just execute setup and select upgrade and the instance name, and yours says I need to run setup from the command prompt with the SKUUPGRADE flag.
Which is the correct answer I have three named instances of SQL 2005 Standard I need to upgrade to SQL 2005 Enterprise. They are all currenlty at SP2
Madhu
Thanks Madhu. I assume I will need to only reapply sp2 once the upgrade is complete correct
After upgrading to SQL Server 2005 from another edition of SQL Server 2005, you must re-apply any hotfix or service pack updates to the upgraded SQL Server instance.
Check this link for cumulative update for SQL Server 2005
http://support.microsoft.com/kb/913089/
Madhu
We have SQL 2000 Ent version and now wish to upgrade to SQL 2005 Standard. I tried but was blocked during the process. Is there around this
We have SQL 2000 Ent version and now wish to upgrade to SQL 2005 Standard. I tried but was blocked during the process.
you can perform upgrade from SQL Server 2000 Enterprise Edition SP3 or later1SQL Server 2005 Enterprise Edition
Thanks for all the help the upgrade to Enterprise addition ran clean on all three instances. But it looks like I'll have to run it for Analysis services separately.