Source Control is a Microsoft SQL Server Management Studio (SSMS) add-in that is designed to manage database changes in most well-known version control systems. With the help of the tool, you can version-control database schemas and data, roll back unwanted changes, handle static data conflicts, and maintain the integrity of the database. Source Control’s functionality allows you to link your database to Team Foundation Server (TFS), which is presently known as Azure DevOps Server. This product from Microsoft covers the entire application lifecycle and provides version control as well as DevOps capabilities.
This topic explains how to link a database to Team Foundation Server (TFS).
Point to Source Control, and then click Link database to source control… on the shortcut menu.
The Link Database To Source Control wizard opens.
On the Link tab of the wizard, click ‘+’ in the Source control repository field.
The Source Control Repository Properties dialog box opens.
Select Team Foundation Server (TFS) from the Source Control system drop-down list box.
In Source control settings, specify:
Server URL, Username and Password for the TFS server. Alternatively, select the Use Windows authentication check-box to use Windows authentication when logging in TFS.
>To get proper settings for Server URL, Username and Password, contact your system administrator.
Click Link. If a database is linked to source control successfully, a database icon in Object Explorer will be changed to show that a database is linked.
If linking a database to TFS was unsuccessful, and you see the ‘Can not find local client for TFS’ error, install Team Foundation Server Object Model: