Enabling and setup of Team Foundation Server (TFS) plugin for Microsoft SQL Server Management Studio

In this article, the version in use are TFS 2017 and Microsoft SQL server version 2014 and Microsoft Visual Studio (VS) 2013 and Microsoft Visual Studio 2015.

First we have to download the MMS plugin for TFS (Microsoft Visual Studio Team Foundation Server 2013 & 2015 MSSCCI Provider 32-bit).

https://marketplace.visualstudio.com/items?itemName=TFSPowerToolsTeam.MicrosoftVisualStudioTeamFoundationServer20132015M

After installing go to MMS > tools > options > Source Control and select from the “Current source control plugin-in” the Team Foundation Server MSSCCI Provider.

MMS TFS Plugin
MMS TFS Plugin

Now in order to use it, create a new solution or project in MMS and check the box “add to source control”.

Create queries and save it and check it into TFS. I normally use it to store the alter queries for views. Right click any view in MMS and select “script view as” then select “alter to file” and save it where your project or solution is stored. Then in windows explorer drag and drop this file into the MMS solution or project under folder queries.