0 Comments

If you have a SQL Express 2005 installation with SQL Management Studio express installed these four commands will do a silent upgrade to 2008.

SQL Server Express

First extract the contents of the SQL Express download into a directory.

        SQLEXPRWT_x86 /EXTRACT
(or whatever .exe you downloaded.)

Install Windows Installer 4.5 and Windows Powershell.

Then remove SQL Tools 2005
        msiexec /quiet /Uninstall {58D379F7-62BC-4748-8237-FE071ECE797C}

Remove Management Studio
        msiexec /quiet /Uninstall {20608BFA-6068-48FE-A410-400F2A124c27}

Ugrade the SQL Engine.
        SETUP.EXE /QUIET /ACTION=upgrade /INSTANCENAME=SQLExpress

Install Management Studio 2008 Express
        SETUP.EXE /QUIET /ACTION=Install /FEATURES=Tools /INSTANCENAME=SQLExpress

http://devspeed.spaces.live.com/Blog/cns!34211943A0184E9C!204.entry