I want to Upgrade TFS 2015 with sql server 2012 to TFS 2017 with sql server 2014. the problem is, all the collection are backuped from TFS 2015 with planed backup , but without detached collections. now I have already install the tfs 2017 . what should I now proceed, I got error Upgrade Assisit find the version 2012 is not compitible.
2 Answers
2
votes
Yes, for TFS 2017 , the support SQL Server version is SQL Server 2016 & SQL Server 2014. TFS 2017 will no longer support SQL 2012.
If you want to upgrade a TFS with SQL upgrade. Ordinarily, the first thing is backup TFS database - update the SQL server- restore database and then proceed to the inplace-upgrade of TFS.
You could take a look at this article for the upgrading, it including In-Place Upgrade and Migration based upgrade.
In your case, you could create a new SQL 2014 instance and remapping the TFS databases to new instance, and then upgrading to TFS 2017. Add detail steps to remap TFS databases.
0
votes
You have two choices :
- You uninstall TFS 2017 and reinstall 2015 to restore your TFS from the Tfs_Configuration through the TFS Administration Console, upgrade SQL Server then proceed to the inplace-upgrade of TFS.
- Upgrade your SQL Server instance to 2014 and upgrade your DB through the TFS Administration Console.
