How to: Use Source Control with SQL Server Management Studio

Source control is available in SQL Server Management Studio when a source control client is installed on the computer. Database objects are not directly protected by the source control provider, but you can create scripts of database objects and save the scripts under source control. After installing the source control client, follow the following steps to use the source control client.

To enable SQL Server Management Studio to use a source control client

  1. In Management Studio, on the Tools menu, click Options, expand Source Control, and then click the Plug-in Selection page.

  2. In the Current source control plug-in box, select the source control product.

  3. On the File menu, point to Source Control and then click the appropriate option. Solutions and the projects, scripts, and files they contain can be added to source control or opened from source control.

  4. On the View menu, click Pending Checkins to see the status of the solution that you have checked out.