Darin's profileDevSpeedBlogListsGuestbook Tools Help

    Upgrade from SQL Express 2005 to 2008

    If you have a SQL Express 2005 installation with Sql Management Studio express installed these commands will do a silent upgrade to 2008.
     
    First extract the contents of the SQL Express download into a directory.
            SQLEXPRWT_x86 /EXTRACT
     
    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
     

    Comments (2)

    Please wait...
    Sorry, the comment you entered is too long. Please shorten it.
    You didn't enter anything. Please try again.
    Sorry, we can't add your comment right now. Please try again later.
    To add a comment, you need permission from your parent. Ask for permission
    Your parent has turned off comments.
    Sorry, we can't delete your comment right now. Please try again later.
    You've exceeded the maximum number of comments that can be left in one day. Please try again in 24 hours.
    Your account has had the ability to leave comments disabled because our systems indicate that you may be spamming other users. If you believe that your account has been disabled in error please contact Windows Live support.
    Complete the security check below to finish leaving your comment.
    The characters you type in the security check must match the characters in the picture or audio.

    To add a comment, sign in with your Windows Live ID (if you use Hotmail, Messenger, or Xbox LIVE, you have a Windows Live ID). Sign in


    Don't have a Windows Live ID? Sign up

    Michaelwrote:
    Thank you!

    exactly what I needed. Worked without problems. Only used the upgrade-Action though because I had the management tools from the Standard-Edition installed previously.
    Aug. 17
    t gwrote:
    Nice! That was helpful.
    Aug. 3

    Trackbacks

    The trackback URL for this entry is:
    http://devspeed.spaces.live.com/blog/cns!34211943A0184E9C!204.trak
    Weblogs that reference this entry
    • None