Developing Solutions and Projects in SQL Server Management Studio (SSAS)
SQL Server Management Studio is a management and administration environment, similar to Microsoft Visual Studio 2005, used primarily to administer instances of Analysis Services, SQL Server, and Reporting Services. With SQL Server Management Studio, you can manage Analysis Services objects (perform back-ups, processing, and so on), and you can also create new objects directly on an existing Analysis Services instance. SQL Server Management Studio provides an Analysis Server Scripts project in which you can save scripts written in Multidimensional Expressions (MDX), Data Mining Extensions (DMX), and XML for Analysis (XMLA). Usually, Analysis Server Scripts projects are used for performing management tasks or re-creating objects, such as databases and cubes, on Analysis Services instances. Such projects can be saved as part of a solution and integrated with source code control.
SQL Server Management Studio allows you to directly manipulate and apply changes to objects on an Analysis Services instance. Because changes are immediately applied, the term "immediate mode" is used throughout SQL Server Books Online to describe business intelligence solutions implemented by SQL Server Management Studio.
For more information about developing solutions and projects in SQL Server Management Studio, see Developing Solutions and Projects in SQL Server Management Studio.
Project Templates
A SQL Server Management Studio solution consists of one or more of the project templates described in the following table.
| Project | Description |
|---|---|
Analysis Server Scripts |
Contains DMX, MDX, and XMLA scripts for Analysis Services, as well as connections to Analysis Services instances against which these scripts can be executed. For more information, see Developing an Analysis Server Scripts Project (SSAS). |
SQL Mobile Scripts |
Contains SQL scripts for SQL Server 2005 Mobile Edition, as well as connections to SQL Server Mobile instances against which these scripts can be executed. For more information, see SQL Server Mobile documentation. |
SQL Server Scripts |
Contains Transact-SQL and XQuery scripts for a SQL Server 2005 Database Engine instance, as well as connections to SQL Server Database Engine instances against which these scripts can be executed. For more information, see SQL Server Database Engine. |
See Also
Concepts
Developing Analysis Services Solutions and Projects (SSAS)
Developing an Analysis Server Scripts Project (SSAS)