Skip to content

files-that-manage-solutions-and-projects.md

Latest commit

 

History

History
54 lines (45 loc) · 3.82 KB

files-that-manage-solutions-and-projects.md

File metadata and controls

54 lines (45 loc) · 3.82 KB
title Files That Manage Solutions and Projects
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
projects [SQL Server Management Studio], files
.ssmssln files
.ssmsmobileproj files
.ssmsasproj files
.ssmssqlproj files
.sqlsuo files
files [SQL Server Management Studio], projects
ms.assetid e19d2859-0b97-4727-ac27-c4c226d86b2f
author markingmyname
ms.author maghan

Files That Manage Solutions and Projects

[!INCLUDEappliesto-ss-asdb-asdw-pdw-md] This topic describes the file types that are specific to [!INCLUDEmsCoName] [!INCLUDEssManStudioFull]. By default, all solutions and their projects are created in \My Documents\SQL Server Management Studio Projects.

Management Studio Solution Files

[!INCLUDEssManStudioFull] uses different file types than [!INCLUDEmsCoName] [!INCLUDEssBIDevStudioFull] or [!INCLUDEmsCoName] Visual Studio. This means you cannot open a [!INCLUDEssManStudioFull] solution in [!INCLUDEssBIDevStudioFull] or in Visual Studio. [!INCLUDEssManStudioFull] solution files allow Solution Explorer to display a graphical interface for managing your files.

Extension File type Description Created by
.ssmssln [!INCLUDEssManStudioFull] Solution Object Provides the environment with references to the location on disk of [!INCLUDEmsCoName] [!INCLUDEssNoVersion] projects, project items, and solution [!INCLUDEssManStudioFull]

Management Studio Project Files

In the same way that solutions contain solution files that manage objects in a solution, projects contain project files. The type of project file that [!INCLUDEssManStudioFull] creates for a project depends on the template used to create the project. The following table describes the type of file created for each project.

Extension Project template
.ssmssqlproj [!INCLUDEssNoVersion] Scripts Project
.ssmsasproj [!INCLUDEssASnoversion] Scripts Project

Location of Solution-Level Files

By default, solution-level files are created in the physical directory of the first project that is created with the solution. You can specify a directory for the solution by creating a solution, or you can specify the directory when you create a new project.

If you have a directory structure similar to the logical structure shown in Solution Explorer, project and solution files are easier to locate and share with other developers on a team.

See Also

Manage Files with Encoding
Miscellaneous Files
Solution Explorer
Solutions (SQL Server Management Studio)
Projects (SQL Server Management Studio)
Solution Explorer Source Control