locked
Upgrade from sql 2005 to 2014 RRS feed

  • Question

  • Hi,

    Is it okay to Upgrade a sql server 2005 to 2014 directly ??

    Or do I need to upgrade it to 2008 & 2012 first ??

    If no, then can I upgrade sql server 2008 to 2014 directly ?? Please advice. Thanks. 


    Regards, Kunjay Shah


    • Edited by kunjay15 Tuesday, May 26, 2015 6:18 PM
    Tuesday, May 26, 2015 6:14 PM

Answers

  • You can upgrade SQL Server 2005 to SQL Server 2014 directly make sure

    1. SQL Server 2005 is patched to SP4

    2 You first run SQL Server 2014 upgrade advisor to know about breaking changes if any

    Please refer to upgrade matrix


    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My Technet Wiki Article

    MVP

    • Marked as answer by kunjay15 Tuesday, May 26, 2015 6:23 PM
    Tuesday, May 26, 2015 6:23 PM