Skip to content

build-database-projects-by-using-sql-server-management-studio.md

Latest commit

 

History

History
68 lines (45 loc) · 4.61 KB

build-database-projects-by-using-sql-server-management-studio.md

File metadata and controls

68 lines (45 loc) · 4.61 KB
title Build Database Projects
ms.prod sql
ms.prod_service sql-tools
ms.reviewer
ms.technology ssms
ms.topic conceptual
helpviewer_keywords
scripts [SQL Server], database projects
database projects [SQL Server]
projects [SQL Server Management Studio], about projects
projects [SQL Server Management Studio]
ms.assetid c2e80045-894d-44cf-b65c-e547ed738947
author markingmyname
ms.author maghan
ms.custom seo-lt-2019
ms.date 01/19/2017

Build Database Projects by Using SQL Server Management Studio

[!INCLUDEappliesto-ss-asdb-asdw-pdw-md]

A database script project is an organized set of scripts, connection information, and templates that are all associated with a database or one part of a database. [!INCLUDEmsCoName] [!INCLUDEssNoVersion] provides the [!INCLUDEssManStudioFull] for administering and designing [!INCLUDEssNoVersion] databases within the context of a script project. [!INCLUDEssManStudioFull] includes designers, editors, guides and wizards to assist users in developing, deploying and maintaining databases.

SQL Server Management Studio

[!INCLUDEssManStudioFull] is a suite of administrative tools for managing the components belonging to [!INCLUDEssNoVersion]. This integrated environment allows users to perform a variety of tasks, such as backing up data, editing queries, and automating common functions within a single interface.

[!INCLUDEssManStudioFull] includes the following tools:

  • Code Editor is a rich script editor for writing and editing scripts. [!INCLUDEssManStudioFull] provides four versions of the Code Editor; the [!INCLUDEssDE] Query Editor for [!INCLUDEtsql] scripts, the DMX Query Editor, the MDX Query Editor, and the XML/A Query Editor.

  • Object Explorer for locating, modifying, scripting or running objects belonging to instances of [!INCLUDEssNoVersion].

  • Template Explorer for locating and scripting templates.

  • Solution Explorer for organizing and storing related scripts as parts of a project.

  • Properties Window for displaying the current properties of selected objects.

[!INCLUDEssManStudioFull] supports efficient work processes by providing:

  • Disconnected access. You can write and edit scripts without connecting to an instance of [!INCLUDEssNoVersion].

  • Scripting from any dialog box. You can create a script from any dialog box so that you can read, modify, store and reuse the scripts after you create them.

  • Nonmodal dialog boxes. When you access a UI dialog box you can browse other resources in [!INCLUDEssManStudioFull] without closing the dialog box.

Solutions and Script Projects

Solution Explorer is a utility to store and reopen database solutions. Solutions organize related script projects and files. Script projects store [!INCLUDEssNoVersion] script files, SQL templates, connection information and other miscellaneous files. When a script is saved in a script project, users are able to:

  • Maintain version control on scripts.

  • Store results options with a script.

  • Organize related scripts in a single script project.

  • Save connection information with scripts.

Solution Explorer is a tool for developers who are creating and reusing scripts that are related to the same project. If a similar task is required later, you can use group of scripts that were stored in a project. If you have created applications by using [!INCLUDEmsCoName] [!INCLUDEvsprvs], you will find Solution Explorer very familiar.

A solution consists of one or more script projects. A project consists of one or more scripts or connections. A project may also include nonscript files.

See Also

Use SQL Server Management Studio
Writing, Analyzing, and Editing Queries with SQL Server Management Studio
Solutions (SQL Server Management Studio)