Bạn đang xem: Sql server management studio
In this article
SQL vps Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure. Use SSMS to access, configure, manage, administer, & develop all components of SQL Server, Azure SQL Database , Azure SQL Managed Instance, SQL hệ thống on Azure VM, & Azure Synapse Analytics. SSMS provides a single comprehensive utility that combines a broad group of graphical tools with many rich script editors to provide access khổng lồ SQL hệ thống for developers & database administrators of all skill levels.
SQL hệ thống Management Studio components
|Use Object Explorer khổng lồ view and manage all of the objects in one or more instances of SQL Server.||Object Explorer|
|Use Template Explorer to build and manage files of boilerplate text that you use to lớn speed the development of queries và scripts.||Template Explorer|
|Use the deprecated Solution Explorer khổng lồ build projects used to manage administration items such as scripts and queries.||Solution Explorer|
|Use the visual design tools included in Management Studio khổng lồ build queries, tables, & diagram databases.||Visual Database Tools|
|Use the Management Studio language editors to interactively build & debug queries & scripts.||Query & Text Editors|
SQL server Management Studio for Business Intelligence
To access, configure, manage, và administer Analysis Services, Integration Services, & Reporting Services, use SQL vps Management Studio. Although all three business intelligence technologies rely on SQL hệ thống Management Studio, the administrative tasks associated with each of these technologies are slightly different.
To create & modify Analysis Services, Reporting Services, and Integration Services solutions, use SQL hệ thống Data Tools (SSDT), not SQL server Management Studio. SQL hệ thống Data Tools (SSDT) is a development environment that is based on trinhde.vnVisual Studio.
Manage Analysis Services Solutions using SQL hệ thống Management Studio
SQL server Management Studio enables you khổng lồ manage Analysis Services objects, such as performing back-ups and processing objects.
Management Studio provides an Analysis Services Script project in which you develop và save scripts written in Multidimensional Expressions (MDX), Data Mining Extensions (DMX), and XML for Analysis (XMLA). You use Analysis Services Scripts projects lớn perform management tasks or re-create objects, such as database và cubes, on Analysis Services instances. For example, you can develop an XMLA script in an Analysis Services Script project that creates new objects directly on an existing Analysis Services instance. The Analysis Services Scripts projects can be saved as part of a solution và integrated with source code control.
For more information about how to lớn use SQL server Management Studio, see Developing and Implementing Using SQL vps Management Studio.
Manage Integration Services Solutions using SQL vps Management Studio
SQL vps Management Studio enables you lớn use the Integration Services service to manage packages and monitor running packages. You can also use Management Studio khổng lồ organize packages into folders, run packages, import & export packages, migrate Data Transformation Services (DTS) packages, & upgrade Integration Services packages.
Manage Reporting Services Projects using SQL hệ thống Management Studio
Use SQL hệ thống Management Studio to lớn enable Reporting Services features, administer the server và databases, & manage roles & jobs.
You manage shared schedules by using the Shared Schedules folder, & manage report vps databases (ReportServer, ReportServerTempdb). You also create a RSExecRole in the Master system database when you move a report server database lớn a new or different SQL vps Database Engine. For more information about these tasks, see the following articles:
You also manage the vps by enabling và configuring various features, setting vps defaults, và managing roles và jobs. For more information about these tasks, see the following articles:
Non-English language versions of SQL vps Management Studio (SSMS)
The block on mixed languages thiết lập has been lifted. You can install SSMS German on a French Windows. If the OS language doesn"t match the SSMS language, the user needs lớn change the language under Tools > Options > International Settings. Otherwise, SSMS shows the English UI.
For more information about different locale with previous versions, reference Install non-English language versions of SSMS.
Support Policy for SSMS
SSMS runs on Windows (AMD or Intel) only. If you need a tool that runs on platforms other than Windows, take a look at Azure Data Studio. Azure Data Studio is a cross-platform tool that runs on macOS, Linux, as well as Windows. For details, see Azure Data Studio.
For more information about SSMS, common tasks, và related tools, see the following articles:
Contribute to lớn SQL documentation
Did you know that you can edit SQL content yourself? If you bởi so, not only vày you help improve our documentation, but you also get credited as a contributor to lớn the page.