Solutions (SQL Server Management Studio)
Applies to: SQL Server (all supported versions) Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics 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.
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.
|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|