locked
Migrating to TFS 2017 from 2015 RRS feed

  • Question

  • We currently run TFS 2015 and use SQL Server 2012 as its database server. I would like to migrate to TFS 2017 but don't really want to move the database off this server. I see in the requirements that TFS 2017 is only supported on SQL Server 2014/16.

    My question is: Is this an absolute or only required if you need support from Microsoft? I can't think of any database engine changes from 2012 to 2014 apart from spatial indexes that might effect running the product on an older version of SQL.

    Regards

    Andrew Lackenby

    Wednesday, September 13, 2017 9:46 AM

Answers

  • hi Andew,

    the installer refuses to upgrade if you're using SQL 2012.

    so you need to upgrade to SQL 2014 or SQL 2016.

    with TFS 2018 appearing on the horizon you should wait another 2-3 month and than upgrade directly to TFS 2018.

    if you want to upgrade to TFS 2017 than you should upgrade to SQL 2016 otherwise you need to upgrade SQL Server again when upgrading to TFS 2018 as TFS 2018 only supports SQL Server 2016 and upcoming SQL Server 2017.


    Please use "Mark as Answer" if my post solved your problem and use "Vote As Helpful" if a post was useful.

    Wednesday, September 13, 2017 10:58 AM

All replies

  • hi Andew,

    the installer refuses to upgrade if you're using SQL 2012.

    so you need to upgrade to SQL 2014 or SQL 2016.

    with TFS 2018 appearing on the horizon you should wait another 2-3 month and than upgrade directly to TFS 2018.

    if you want to upgrade to TFS 2017 than you should upgrade to SQL 2016 otherwise you need to upgrade SQL Server again when upgrading to TFS 2018 as TFS 2018 only supports SQL Server 2016 and upcoming SQL Server 2017.


    Please use "Mark as Answer" if my post solved your problem and use "Vote As Helpful" if a post was useful.

    Wednesday, September 13, 2017 10:58 AM
  • Hi Andew,

    Does Daniel's reply help you?

    Best regards,


    MSDN Community Support Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Monday, September 18, 2017 8:20 AM