locked
SQL 2005 to SQL 2014 RRS feed

  • Question

  • The following MSDN reference http://msdn.microsoft.com/en-us/library/ms143393%28v=sql.120%29.aspx says

    SQL Server 2014 supports upgrade from the following versions of SQL Server:

    • SQL Server 2008 SP3 or later
    • SQL Server 2008 R2 SP2 or later
    • SQL Server 2012 SP1 or later

    However, in our testing, it is possible to upgrade from SQL 2005 SP4 to SQL 2014.  There are no messages or detection errors when doing so.  Will the final release of SQL 2014 support upgrading from SQL 2005 directly or will there be detection added to the installation to prevent it?

    Wednesday, January 15, 2014 10:08 PM

Answers

  • Hello,

    SQL Server 2005 won’t be supported as a valid upgrade path when SQL Server 2014 RTM is released as the article you posted states. The behavior you are seeing with the CTP version of SQL Server 2014 maybe is part due to some binaries of the SQL Server 2012 version still in use on the CTP version.

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com




    • Edited by Alberto MorilloMVP Wednesday, January 15, 2014 10:37 PM
    • Proposed as answer by Sofiya Li Thursday, January 16, 2014 3:42 AM
    • Marked as answer by duncanph Thursday, January 16, 2014 4:10 PM
    Wednesday, January 15, 2014 10:33 PM

All replies

  • Hello,

    SQL Server 2005 won’t be supported as a valid upgrade path when SQL Server 2014 RTM is released as the article you posted states. The behavior you are seeing with the CTP version of SQL Server 2014 maybe is part due to some binaries of the SQL Server 2012 version still in use on the CTP version.

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com




    • Edited by Alberto MorilloMVP Wednesday, January 15, 2014 10:37 PM
    • Proposed as answer by Sofiya Li Thursday, January 16, 2014 3:42 AM
    • Marked as answer by duncanph Thursday, January 16, 2014 4:10 PM
    Wednesday, January 15, 2014 10:33 PM
  • Thanks! That is the information I needed.
    Thursday, January 16, 2014 4:10 PM
  • In the RTM of SQL Server 2014, SQL 2005 upgrade is supported.

    See Supported Version and Edition Upgrades

    David


    David http://blogs.msdn.com/b/dbrowne/

    Wednesday, March 26, 2014 6:10 PM