Post reply

Can't upgeane SQL Server 2014 Developer to SQL Server 2016 Developer

  • June 10, 2016 at 8:50 am

    #317113

    According to this page (https://msdn.microsoft.com/library/ms143393), full upgrade from is supported.

     

    However, I was only able to upgrade Share Features and Redistributable Features. I was never offered the option to upgrade my SQL Server 2014 Developer instance.

     

    Even though the UI didn't match the instructions:

     

    As can be seen, there's no Upgrade from SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, or SQL Server 2014, only Upgrade from a previous version of SQL Server.

     

    I tried it anyway but nothing:

     

     

    I already had SQL Server Management Studio 2016 installed.

     

    Has anyone been able to do this?

  • June 10, 2016 at 9:45 am

    #1884432

    I would check the setup logs.

    I had an issue but that was with SSRS and had to look throught the logs to find that out.

    Might be here somewhere

    C:\Program Files\Microsoft SQL Server\120\Setup Bootstrap\Log

    Catch-all queries done right [/url]
    Gail Shaw's Performance Blog[/url]

  • June 10, 2016 at 10:54 am

    #1884446

    I realized I haven't upgraded any instances.

    I've got a 2012 one handy I can upgrade, so once I get Dev edition down, I'll try it.

  • June 10, 2016 at 11:31 am

    #1884456

    It turns out that, instead of downloading SQL Server 2014 Developer Edition from my MSDN subscriber downloads I downloaded it from the Visual Studio Essentials download.

    Because only one version was available, it never crossed my mind it was the x86 version instead on the x64 version.

    And SQL Server 2016 seems to be x64 only.

    Would it be possible to upgrade SQL Server 2014 x86 to SQL Server x64?

  • June 10, 2016 at 11:53 am

    #1884459

    Certainly in the past, no: https://blogs.msdn.microsoft.com/cindygross/2009/07/07/x64-windows-upgrade-from-32bit-sql-server-to-64bit-sql-server/

    And not still: https://technet.microsoft.com/en-us/library/ms143393.aspx

    This is cross platform.

    The only thing I know to do here is

    a) install a named instance. Backup and restore dbs.

    b) script out logins/jobs/linked servers. Backup dbs. Uninstall x86 and install x64.

Viewing 5 posts - 1 through 4 (of 4 total)

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