Solution Explorer

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW)

The Solution Explorer pane in Microsoft SQL Server Management Studio 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

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

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 SQL Server Management Studio.

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)
Provides information about the files used by SQL Server Management Studio to manage solutions and files. Files That Manage Solutions and Projects