Post reply

Upgrade Architecture Mismatch

  • January 14, 2017 at 7:28 pm

    #317600

    I am trying to upgrade SQL Server 2012 Developers Edition (32 Bit) to SQL Server 2012 Standard Edition (64 Bit) and I am getting an error message saying "Upgrade Architecture Mismatch". Under Options in the SQL Server Installation Center, I can only select x64 processor type. x86 option is grayed out.

    How do I get around this error message to perform the upgrade?

    Thanks in advance.

  • January 14, 2017 at 10:02 pm

    #1922780

    mceventphoto - Saturday, January 14, 2017 7:28 PM

    I am trying to upgrade SQL Server 2012 Developers Edition (32 Bit) to SQL Server 2012 Standard Edition (64 Bit) and I am getting an error message saying "Upgrade Architecture Mismatch". Under Options in the SQL Server Installation Center, I can only select x64 processor type. x86 option is grayed out.

    How do I get around this error message to perform the upgrade?

    Thanks in advance.

    The Developers Edition is really the Enterprise Edition with special licensing.  Is there code or other functionality in the database that requires the Enterprise Edition rather than the Standard Edition?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • January 17, 2017 at 6:59 am

    #1923159

    Jeff Moden - Saturday, January 14, 2017 10:02 PM

    mceventphoto - Saturday, January 14, 2017 7:28 PM

    I am trying to upgrade SQL Server 2012 Developers Edition (32 Bit) to SQL Server 2012 Standard Edition (64 Bit) and I am getting an error message saying "Upgrade Architecture Mismatch". Under Options in the SQL Server Installation Center, I can only select x64 processor type. x86 option is grayed out.

    How do I get around this error message to perform the upgrade?

    Thanks in advance.

    The Developers Edition is really the Enterprise Edition with special licensing.  Is there code or other functionality in the database that requires the Enterprise Edition rather than the Standard Edition?

    Hi Jeff,

    I ended up doing a complete uninstall of the 32 bit version before I was able to install the 64 bit version. I initially installed Standard Edition, but could not re-attach one of the databases. I got an error message saying that "database cannot be started in this edition of SQL Server because part or all of object 'Numbers' is enabled with data compression or vardecimal storage format. Data compression and vardecimalstorage format are only supported on SQL Server Enterprise Edition." In the end, I ended up installing SQL 2012 Enterprise Edition to get all the databases to re-attach without any error.

    Thanks
    MC

Viewing 3 posts - 1 through 2 (of 2 total)

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