Upgrading from SQL 2005 Developer Edition

  • Hi guys,

    I installed and have been playing with SQL 2008 on a server. My company is going to go ahead with 2008 and so I wanted to upgrade my SQL 2005 Developer Edition to 2008 on my pc. I get a message that "SQL Server 2008 Feature Upgrade" failed.

    According to this the developer edition should upgrade. Or am I misreading it?

    My version is Microsoft SQL Server 2005 - 9.00.3073.00 (Intel X86) Aug 5 2008 12:31:12 Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 3).

    I'm trying to install from here

    What am I missing?

    :unsure:

  • Hi Robert,

    Which edition is it that you are installing? Makes sure you are Ok from that perspective first: http://technet.microsoft.com/en-us/library/ms143506.aspx.

    Once that's sorted, move on to this blogpost, written by one of the PSS escalation engineers:

    "How to fix your SQL Server 2008 Setup before you run setup...", http://blogs.msdn.com/psssql/archive/2008/09/30/how-to-fix-your-sql-server-2008-setup-before-you-run-setup.aspx. It will inform you about all prereqs and then walk you through the setup step by step.

    Your setup log files gives your more information about what went wrong and alredy in the GUI i suspect you can see what feature it is failing on.

    HTH!

    /Elisabeth

    elisabeth@sqlserverland.com
    MCITP | MCT
    http://sqlblog.com/blogs/elisabeth_redei/
    http://linkedin.com/in/elisabethredei

  • Are you doing an upgrade, or in-place separate install?

    I have installed many times 2008 after 2005, or 2005 after 2008 install

    so that you have both SSMS 2005 and SSMS 2008 should you need them

    On my computer now, I have SQL Server 2008 instance + SSMS2008/BIDS2008 and SSMS2005/BIDS2005

    But either way, install log is a good start

    SQLServerNewbie MCITP: Database Administrator SQL Server 2005
  • Elisabeth and Jerry,

    Thanks for the reply. I'm trying to do an upgrade.

    I'm trying to install version 10.00.1600.22 "Microsoft® SQL Server® 2008 Enterprise Evaluation: Trial Experience for Developers". Trying to upgrade SQL 2005 Developer Edition.

    The step-by-step process you sent is informative but appears to refer only to new installations.

    I ran the upgrade advisor and passed all the tests there, no I'm unsure why the current install fails.

    The logs SqlSetup.log and SqlSetup_1.log show no problems.

  • Hi again,

    Yes but the prerequisites are the same. Which feature is it failing on?

    /Elisabeth

    elisabeth@sqlserverland.com
    MCITP | MCT
    http://sqlblog.com/blogs/elisabeth_redei/
    http://linkedin.com/in/elisabethredei

  • can't do developer to enterprise version. Need to either upgrade dev edition to enterprise, then to 2008 enterprise trial or get the 2008 developer edition from msdn download site if you still have a MSDN account. It is fun trying to find it, but just keep clicking on links to downloads and keys once signed into MSDN.

    sql 2005 dev edition alongside 2008 enterprise (no msdn for me for now....trying to get it) killed my SSIS. 2005 version is removed and SSIS version 10 replaces it. At least in my install.

  • OK I have a similar problem but not the same. Two years ago I tried to install SQL Server 2005 Standard Edition. It automatically gave me the Developer Edition so I went with it. Now I am trying to upgrade my installation to SQL Server 2008.

    I ran the Upgrade Advisor and the only problems it turned up were problems that everybody would get (warnings about the full-text changes, etc.). So I cleared all the problems manually and it looked like I was good to go. But when I ran the upgrade, I got to the "upgrade rules" and only one failed, with this message:

    Rule "SQL Server 2008 Feature Upgrade" failed.

    The specified edition upgrade is not supported. For information about supported upgrade paths, see the SQL Server 2008 version and edition upgrade matrix in Books Online.

    So I figured it was trying to install Standard 2008 over Developer 2005, which is not a supported thing. So then I tried a separate instance of 2008 (instead of an upgrade) and it informed me that it was going to install 2008 Developer! (There is no explicit choice to select developer in either installation path, as far as I can tell). I then decided I didn't want two side-by-side installations and cancelled out of that.

    What I really want is to upgrade 2005 Developer to 2008 Developer. Does anybody know how to make the installer do this, since there are no explicit options to select Developer at all? Thanks. P.S. I am installing on Windows 2003 Server.

  • msdn site, get the developer edition. must be current pro or premium

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply