How do you work with TFS source control in SQL Server Management Studio 2016?

Posted: 27.11.2016 5.56.48 (EET/GMT+2)

The latest SQL Server 2016's management utility, SQL Server Management Studio (SSMS) is now based on Visual Studio 2015, which means that the way it handles source control systems has changed. In previous versions (say, SSMS 2014 and 2012) you could install the MSSCCI provider, but in the latest 2016 this doesn't work anymore.

Instead, you can manually enable the same version control tools that you have in Visual Studio 2015: think Team Explorer. There's a nice blog post about specifically this on Technet blogs. Follow those instrcutions, and you will again be able to connect to Team Foundation Server (TFS) through SQL Server Management Studio 2016.

Happy hacking!