Solution Explorer Source Control


Microsoft SQL Server Management Studio Solution Explorer can be integrated into a separate source control system. Once a solution or project is integrated into a source control system, you can control file access and versioning for the scripts and queries in your projects.

System_CAPS_ICON_important.jpg Important

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

Source control refers to a system in which a central piece of server software stores and tracks file versions, and also controls access to files. A typical source control system includes a source control provider and two or more source control clients. SQL Server Management Studio can be integrated with a source control service. This means you can use the tool as a client for your source control provider. Without leaving the environment, you can manage your individual and team projects easily. The source control provider is not included with Management Studio.

To select a source control provider

  1. Install the client portion of your source control provider.

  2. In Management Studio, on the Tools menu, click Options.

  3. In the Options dialog box, expand Source Control, and then click the Plug-in Selection page.

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

Source Control BasicsDefines basic source control terminology, and explains how your project can benefit from using source control services.
Add Solutions and Projects to Source ControlExplains how to use the Management Studio environment to add solutions and projects to source control.
Open Solutions and Projects from Source ControlExplains how to use the Management Studio environment to open source-controlled solutions and projects.
Manage CheckoutsExplains how to check out solutions and files from source control.
Manage CheckinsExplains how to check solutions and files into source control.
Set and Retrieve Version InformationExplains how to retrieve the history of a project or item, retrieve a local copy of an item, or compare two item versions.

Solution Explorer
Solutions (SQL Server Management Studio)
Projects (SQL Server Management Studio)
Files That Manage Solutions and Projects