什么是 SQL Server Management Studio (SSMS)?What is SQL Server Management Studio (SSMS)?

适用于:是SQL Server是Azure SQL 数据库是Azure SQL 数据仓库否并行数据仓库APPLIES TO: yesSQL Server yesAzure SQL Database yesAzure SQL Data Warehouse noParallel Data Warehouse

SQL Server Management StudioSQL Server Management Studio (SSMS) 是用于管理任何 SQL 基础结构的集成环境。(SSMS) is an integrated environment for managing any SQL infrastructure. 使用 SSMS,可以访问、配置、管理和开发 SQL ServerSQL Server、Azure SQL 数据库和 SQL 数据仓库的所有组件。Use SSMS to access, configure, manage, administer, and develop all components of SQL ServerSQL Server, Azure SQL Database, and SQL Data Warehouse. SSMS 在一个综合实用工具中汇集了大量图形工具和丰富的脚本编辑器,为各种技能水平的开发者和数据库管理员提供对 SQL ServerSQL Server 的访问权限。SSMS provides a single comprehensive utility that combines a broad group of graphical tools with a number of rich script editors to provide access to SQL ServerSQL Server for developers and database administrators of all skill levels.

SQL Server Management Studio 组件SQL Server Management Studio components

描述Description 组件Component
使用“对象资源管理器” 查看和管理 SQL ServerSQL Server 的一个或多个实例中的所有对象。Use Object Explorer to view and manage all of the objects in one or more instances of SQL ServerSQL Server. 对象资源管理器Object Explorer
如何使用“模板资源管理器”生成和管理用于加快查询和脚本开发速度的样板文本文件 。How to use Template Explorer to build and manage files of boilerplate text that you use to speed the development of queries and scripts. 模板资源管理器Template Explorer
如何使用不推荐使用的“解决方案资源管理器” 生成用于管理诸如脚本和查询等管理项的项目。How to use the deprecated Solution Explorer to build projects used to manage administration items such as scripts and queries. 解决方案资源管理器Solution Explorer
如何使用 Management StudioManagement Studio中包含的可视化设计工具。How to use the visual design tools included in Management StudioManagement Studio. Visual Database ToolsVisual Database Tools
如何使用 Management StudioManagement Studio 语言编辑器交互式生成和调试查询和脚本。How to use the Management StudioManagement Studio language editors to interactively build and debug queries and scripts. 查询和文本编辑器 (SQL Server Management Studio)Query and Text Editors (SQL Server Management Studio)

适用于商业智能的 SQL Server Management StudioSQL Server Management Studio for Business Intelligence

若要访问、配置和管理 Analysis ServicesAnalysis ServicesIntegration ServicesIntegration ServicesReporting ServicesReporting Services,请使用 SQL Server Management StudioSQL Server Management StudioTo access, configure, manage, and administer Analysis ServicesAnalysis Services, Integration ServicesIntegration Services, and Reporting ServicesReporting Services, use SQL Server Management StudioSQL Server Management Studio. 虽然这三种商业智能技术均依赖于 SQL Server Management StudioSQL Server Management Studio,但与每种技术关联的管理任务却略有不同。Although all three business intelligence technologies rely on SQL Server Management StudioSQL Server Management Studio, the administrative tasks associated with each of these technologies are slightly different.

备注

若要创建和修改 Analysis ServicesAnalysis ServicesReporting ServicesReporting ServicesIntegration ServicesIntegration Services 解决方案,请使用 SQL Server Data Tools (SSDT)SQL Server Data Tools (SSDT),而不是 SQL Server Management StudioSQL Server Management StudioTo create and modify Analysis ServicesAnalysis Services, Reporting ServicesReporting Services, and Integration ServicesIntegration Services solutions, use SQL Server Data Tools (SSDT)SQL Server Data Tools (SSDT), not SQL Server Management StudioSQL Server Management Studio. SQL Server Data Tools (SSDT)SQL Server Data Tools (SSDT) 是一个基于 MicrosoftMicrosoftVisual StudioVisual Studio的开发环境。is a development environment that is based on MicrosoftMicrosoftVisual StudioVisual Studio.

使用 SQL Server Management Studio 管理 Analysis Services 解决方案Managing Analysis Services Solutions Using SQL Server Management Studio

SQL Server Management StudioSQL Server Management Studio 可以管理 Analysis ServicesAnalysis Services 对象,如执行备份和处理对象。enables you to manage Analysis ServicesAnalysis Services objects, such as performing back-ups and processing objects.

Management StudioManagement Studio 提供一个 Analysis ServicesAnalysis Services 脚本项目,可在其中开发并保存使用多维表达式 (MDX)、数据挖掘扩展插件 (DMX) 和 XML for Analysis (XMLA) 编写的脚本。provides an Analysis ServicesAnalysis Services Script project in which you develop and save scripts written in Multidimensional Expressions (MDX), Data Mining Extensions (DMX), and XML for Analysis (XMLA). 可以使用 Analysis ServicesAnalysis Services 脚本项目在 Analysis ServicesAnalysis Services 实例中执行管理任务或重新创建对象(如数据库和多维数据集)。You use Analysis ServicesAnalysis Services Scripts projects to perform management tasks or re-create objects, such as database and cubes, on Analysis ServicesAnalysis Services instances. 例如,可以在 Analysis ServicesAnalysis Services 脚本项目中开发一个 XMLA 脚本,以直接在现有 Analysis ServicesAnalysis Services 实例中创建新的对象。For example, you can develop an XMLA script in an Analysis ServicesAnalysis Services Script project that creates new objects directly on an existing Analysis ServicesAnalysis Services instance. 可以将 Analysis ServicesAnalysis Services 脚本项目保存为解决方案的一部分,以及与源代码管理集成在一起。The Analysis ServicesAnalysis Services Scripts projects can be saved as part of a solution and integrated with source code control.

有关如何使用 SQL Server Management StudioSQL Server Management Studio的详细信息,请参阅 使用 SQL Server Management Studio 进行开发和实现For more information about how to use SQL Server Management StudioSQL Server Management Studio, see Developing and Implementing Using SQL Server Management Studio.

使用 SQL Server Management Studio 管理 Integration Services 解决方案Managing Integration Services Solutions Using SQL Server Management Studio

SQL Server Management StudioSQL Server Management Studio 可以使用 Integration ServicesIntegration Services 服务管理包并监视正在运行的包。enables you to use the Integration ServicesIntegration Services service to manage packages and monitor running packages. 还可以使用 Management StudioManagement Studio 将包组织到文件夹中、运行包、导入和导出包、迁移 Data Transformation Services (DTS) 包以及升级 Integration ServicesIntegration Services 包。You can also use Management StudioManagement Studio to organize packages into folders, run packages, import and export packages, migrate Data Transformation Services (DTS) packages, and upgrade Integration ServicesIntegration Services packages.

使用 SQL Server Management Studio 管理 Reporting Services 项目Managing Reporting Services Projects Using SQL Server Management Studio

可以使用 SQL Server Management Studio 启用 Reporting Services 功能、管理服务器和数据库以及管理角色和作业。Use SQL Server Management Studio to enable Reporting Services features, administer the server and databases, and manage roles and jobs.

可通过使用“共享计划”文件夹来管理共享计划以及管理报表服务器数据库(ReportServer、ReportServerTempdb)。You manage shared schedules by using the Shared Schedules folder, and manage report server databases (ReportServer, ReportServerTempdb). 在将报表服务器数据库移动到新的或不同的 SQL Server 数据库引擎(SQL ServerSQL Server 数据库引擎Database Engine)时,还可以在 Master 系统数据库中创建 RSExecRole。You also create a RSExecRole in the Master system database when you move a report server database to a new or different SQL Server Database Engine (SQL ServerSQL Server 数据库引擎Database Engine). 有关这些任务的详细信息,请参阅以下主题:For more information about these tasks, see the following topics:

也可以通过以下方法来管理服务器:启用并配置各种功能、设置服务器默认设置以及管理角色和作业。You also manage the server by enabling and configuring various features, setting server defaults, and managing roles and jobs. 有关这些任务的详细信息,请参阅以下主题:For more information about these tasks, see the following topics:

非英语语言版本的 SQL Server Management Studio (SSMS)Non-English language versions of SQL Server Management Studio (SSMS)

已解除阻止混合语言设置。The block on mixed languages setup has been lifted. 可以在法语版 Windows 上安装 SSMS 德语版。You can install SSMS German on a French Windows. 如果 OS 语言与 SSMS 语言不匹配,则用户需要在“工具”>“选项”>“国际设置”下更改语言。If the OS language doesn't match the SSMS language, the user needs to change the language under Tools > Options > International Settings. 否则,SSMS 显示英语版 UI。Otherwise, SSMS shows the English UI.

有关早期版本的不同区域设置的详细信息,请参阅安装非英语语言版本的 SSMSFor more information about different locale with previous versions, reference Install non-English language versions of SSMS.

SSMS 的支持策略Support Policy for SSMS

info_tip 获取帮助Get Help

后续步骤Next steps

编辑内容 参与编辑 SQL 文档Contribute SQL documentation

您是否知道,您可以编辑内容自己?Did you know that you could edit the content yourself? 如果这样做,不仅将得到改善我们的文档,而且你将还贷记作为参与者到页。If you do so, not only will our documentation improve, but you'll also be credited as a contributor to the page.