SQL Articles » Upgrade http://www.sqldba.co.nz/blog Thu, 27 Jul 2017 19:31:49 +0000 en-US hourly 1 http://wordpress.org/?v=4.2.2 SQL Server Edition Upgrade http://www.sqldba.co.nz/blog/?p=32 http://www.sqldba.co.nz/blog/?p=32#comments Sat, 25 Feb 2012 06:54:17 +0000 http://www.sqldba.co.nz/blog/?p=32 Continue reading →]]> Edition upgrades on SQL2005 are a completely different kettle of fish compared to SQL 2000.

Whereas in 2000, you pop the cd in the drive and it recognises that you can upgrade the edition and it is all over in a minute, 2005 requires you to perform the upgrade from the command line. You can find the command in books online. Look up “Install SQL Server from the Command Prompt” then go down to parameters and click on SKUUPGRADE. Here is the command to upgrade the default instance of the database engine…

start /wait setup.exe ADDLOCAL=SQL_Engine INSTANCENAME=MSSQLSERVER UPGRADE=SQL_Engine SKUUPGRADE=1 /qb

Note that the commands are case sensitive.

Another point to note is that after the instance is upgraded the installation is now at RTM version. So you have to apply any service packs or hotfixes again.

]]> http://www.sqldba.co.nz/blog/?feed=rss2&p=32 0