How to upgrade express edition to sql 2000 standar | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

How to upgrade express edition to sql 2000 standar

Hi,
How to upgrade sql expression edition to sql server 2005 standard or enterprise edition?
Thanks
S. Ramesh
Ramesh You can do that from command prompt [SKUUPGRADE]
Use the SKUUPGRADE parameter when upgrading from one edition of SQL Server to another edition of SQL Server. Important:
If you use the SKUUPGRADE parameter, Setup will remove all hotfix and service pack updates from the SQL Server instance being upgraded. Once the edition upgrade is complete, you must reapply all hotfix and service pack updates. To perform an edition upgrade of a default instance of SQL Server (SQL Engine only) via unattended Setup, run the following command using either /qb or /qn: start /wait setup.exe ADDLOCAL=SQL_Engine INSTANCENAME=MSSQLSERVER UPGRADE=SQL_Engine SKUUPGRADE=1 /qb Reference:http://msdn2.microsoft.com/en-us/library/ms144259.aspx Satya

Upgrading from SQL Server 2005 Express Edition to Workgroup or Standard Editions
SQL Server Technical Article http://download.microsoft.com/downl…0C-40EB-911F-E7ADEC87F5D5/UpgrExptoWkgStd.doc
MohammedU.
Moderator
SQL-Server-Performance.com
]]>