Skip to content

Latest commit

 

History

History
55 lines (42 loc) · 2.99 KB

File metadata and controls

55 lines (42 loc) · 2.99 KB
title Solution Explorer | Microsoft Docs
ms.custom
ms.date 06/13/2017
ms.prod sql-server-2014
ms.reviewer
ms.technology ssms
ms.topic conceptual
helpviewer_keywords
SQL Server Management Studio [SQL Server], solutions
projects [SQL Server Management Studio], about projects
SQL Server Management Studio [SQL Server], projects
solutions [SQL Server Management Studio], about solutions
SQL Server Management Studio [SQL Server], items
items [SQL Server]
ms.assetid 0df09843-0d4f-4925-bc6c-99265035a0c1
author stevestein
ms.author sstein
manager craigg

Solution Explorer

The Solution Explorer pane in [!INCLUDEmsCoName] [!INCLUDEssManStudioFull] provides containers called projects for managing items such as database scripts, queries, data connections, and files. One or more projects that are related to each other can be combined in a container called a solution.

A solution includes one or more projects, plus files and metadata that help define the solution as a whole. A project is a set of files, plus related metadata such as connection information. Solutions and projects contain items that represent the scripts, queries, connection information and files that you need to create your database solution.

Important

[!INCLUDEssNoteDepFutureAvoid]

Benefits of Using Solutions

Use these containers to:

  • Implement source control on queries and scripts.

  • Manage settings for your solution as a whole or for individual projects.

  • Handle the details of file management while you focus on items that make up your database solution.

  • Add items that are useful to multiple projects in the solution or to the solution without referencing the item in each project.

  • Work on miscellaneous files that are independent from solutions or projects.

The items contained in projects depend on the project type and whether you are using [!INCLUDEssManStudioFull].

Related Tasks

Use the following topics to get started with SQL Server Solutions:

Description Topic
Describes how to collect one or more projects in a solution. Solutions (SQL Server Management Studio)
Describes how to create a project and add items like scripts and connections. Projects (SQL Server Management Studio)
Describes how to integrate solutions or individual projects into a source code control system. Solution Explorer Source Control
Provides information about the files used by [!INCLUDEssManStudioFull] to manage solutions and files. Files That Manage Solutions and Projects