Events
Mar 31, 11 PM - Apr 2, 11 PM
The ultimate SQL, Power BI, Fabric, and AI community-led event. March 31 - April 2. Use code MSCUST for a $150 discount. Prices go up Feb 11th.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Applies to: SQL Server 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.
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
Events
Mar 31, 11 PM - Apr 2, 11 PM
The ultimate SQL, Power BI, Fabric, and AI community-led event. March 31 - April 2. Use code MSCUST for a $150 discount. Prices go up Feb 11th.
Register todayTraining
Module
Introduction to solutions for Microsoft Power Platform - Training
Learn how to transport an existing app and components from one environment to another.
Certification
Microsoft Certified: Azure Solutions Architect Expert - Certifications
As a Microsoft Azure solutions architect, you advise stakeholders and translate business requirements into designs for Azure solutions that align with the Azure Well-Architected Framework and Cloud Adoption Framework for Azure.