| title | Solutions (SQL Server Management Studio) | |||||
|---|---|---|---|---|---|---|
| ms.custom | seo-lt-2019 | |||||
| ms.date | 01/19/2017 | |||||
| ms.prod | sql | |||||
| ms.prod_service | sql-tools | |||||
| ms.reviewer | ||||||
| ms.technology | ssms | |||||
| ms.topic | conceptual | |||||
| helpviewer_keywords |
|
|||||
| ms.assetid | d06a8a05-7201-4055-8cf3-21bcb4e82c25 | |||||
| author | markingmyname | |||||
| ms.author | maghan |
[!INCLUDEappliesto-ss-asdb-asdw-pdw-md] A [!INCLUDEssManStudioFull] 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 [!INCLUDEssManStudio] as a script development platform for [!INCLUDEssDE] and [!INCLUDEssASnoversion]. Use the [!INCLUDEssManStudio] 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 [!INCLUDEssManStudio].
Solutions and projects can be integrated into a [!INCLUDEmsCoName] Visual SourceSafe (VSS) database or other third-party source control providers, for development change tracking and life-cycle management.
| 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 |
Solution Explorer
Projects (SQL Server Management Studio)
Solution Explorer Source Control