Merging two TFS databases RRS feed

  • General discussion

  • We have 2 TFS environments used by two different applications having different set of users. 

    One is TFS 2015 & Another is TFS 2017, we need to merge both of them into one , i'e there will be now only one TFS 2017 which will be having both (TFS 2015 + TFS 2017).

    1st step would be to upgrade the TFS 2015 one to TFS 2017. Now after that we will have 2 separate TFS 2017 .

    Now how to merger them both into one TFS 2017.

    Consider both of them having SQL Server 2014 in the backend.

    Wednesday, February 21, 2018 12:15 PM

All replies

  • Hi Amit,

    You cannot merge two TFS databases, nothing but merging two project collections.  It is not possible without loosing the file version history, etc.. since it causes conflicts with Item Ids of builds, tasks, etc..

    But both the databases can be attached to a single TFS 2017.

    After upgrading the TFS 2015 to TFS 2017.. temporarily host a new TFS 2017 on a different SQL Server just for upgrade.. attach the upgraded databases (assumption is you have now two SQL Servers and you can move upgraded databases, using backup and restore, to your primary TFS 2017's SQL Server) to your primary TFS 2017 Server using "Attach Collection" option from Team Foundation Administration Console -> Team Project Collections. 

    • Edited by 2Power Friday, April 13, 2018 7:33 PM
    Friday, April 13, 2018 7:23 PM