Solutions (SQL Server Management Studio)

Applies to: yesSQL Server (all supported versions) YesAzure SQL Database YesAzure SQL Managed Instance yesAzure Synapse Analytics yesAnalytics Platform System (PDW)

A SQL Server Management Studio solution is a collection of one or more related projects. Projects are containers that developers use to organize related files, such as sets of commonly used administration scripts.

Solution Overview

You can use Management Studio as a script development platform for Database Engine and Analysis Services. Use the Management Studio code editors to develop scripts and queries for relational and multidimensional databases, and collect related scripts and queries together in projects.

Projects can contain:

  • Queries and scripts that implement production processes.

  • Connection information and files used by the queries and scripts.

One or more related projects can be combined in a solution. Solutions and projects can be managed by using the Solution Explorer pane in Management Studio.

Solutions and projects can be integrated into a Microsoft Visual SourceSafe (VSS) database or other third-party source control providers, for development change tracking and life-cycle management.

Solution Tasks

Task Description Topic
Describes how to create a new solution that can then be used to contain one or more projects. Create a New Solution
Describes how to open an existing solution in Solution Explorer. Open an Existing Solution
Describes how to close a solution. Close a Solution
Describes how to delete a solution. Delete a Solution
Describes how to copy items between projects. Copy Items in a Solution
Describes how to delete items in a project, or an entire project. Remove or Delete an Item or Project
Describes how to move items between projects in a solution. Move Items in a Solution
Describes how to rename a solution or the items in the solution. Rename Solutions and Project Items

See Also

Solution Explorer
Projects (SQL Server Management Studio)
Solution Explorer Source Control