什么是 Azure Data Studio?What is Azure Data Studio?

Azure Data Studio是一种跨平台数据库工具,适用于在Windows,MacOS和Linux上使用Microsoft系列内部部署和云数据平台的数据专业人员。Azure Data Studio is a cross-platform database tool for data professionals using the Microsoft family of on-premises and cloud data platforms on Windows, MacOS, and Linux.

此前在预览名称SQL Operations Studio下发布的Azure Data Studio提供了现代化编辑器体验,包括Intellisense,代码片段,源代码控制集成和集成终端。Previously released under the preview name SQL Operations Studio, Azure Data Studio offers a modern editor experience with Intellisense, code snippets, source control integration, and an integrated terminal. 它在设计时考虑了数据平台用户,内置了查询结果集和可自定义的仪表板。It is engineered with the data platform user in mind, with built in charting of query result sets and customizable dashboards.

下载并安装 Azure Data StudioAzure Data StudioDownload and Install Azure Data StudioAzure Data Studio

使用 IntelliSense 的 SQL 代码编辑器SQL code editor with IntelliSense

Azure Data StudioAzure Data Studio 提供了现代、 键盘焦点位于 SQL 编码经验,这与内置功能,例如多个选项卡窗口、 丰富的 SQL 编辑器、 IntelliSense、 关键字完成、 代码段、 代码导航和源代码管理简化日常任务(Git) 的集成。offers a modern, keyboard-focused SQL coding experience that makes your everyday tasks easier with built-in features, such as multiple tab windows, a rich SQL editor, IntelliSense, keyword completion, code snippets, code navigation, and source control integration (Git). 运行按需 SQL 查询、 查看并将结果保存为文本、 JSON 或 Excel。Run on-demand SQL queries, view and save results as text, JSON, or Excel. 编辑数据、组织最喜欢的数据库连接,以及以熟悉的对象浏览体验浏览数据库对象。Edit data, organize your favorite database connections, and browse database objects in a familiar object browsing experience. 若要了解如何使用 SQL 编辑器,请参阅使用 SQL 编辑器来创建数据库对象To learn how to use the SQL editor, see Use the SQL editor to create database objects.

智能 SQL 代码段Smart SQL code snippets

SQL 代码段生成正确的 SQL 语法来创建数据库、 表、 视图、 存储的过程、 用户、 登录名、 角色、 等,并更新现有数据库对象。SQL code snippets generate the proper SQL syntax to create databases, tables, views, stored procedures, users, logins, roles, etc., and to update existing database objects. 使用智能代码片段来快速创建开发或测试目的,数据库的副本和要生成并执行创建和插入脚本。Use smart snippets to quickly create copies of your database for development or testing purposes, and to generate and execute CREATE and INSERT scripts.

Azure Data StudioAzure Data Studio 此外提供了功能,以创建自定义 SQL 代码段。also provides functionality to create custom SQL code snippets. 若要了解详细信息,请参阅创建和使用代码片段To learn more, see Create and use code snippets.

可自定义服务器和数据库仪表板Customizable Server and Database Dashboards

创建丰富的可定制仪表板,以监视并快速解决数据库中的性能瓶颈。Create rich customizable dashboards to monitor and quickly troubleshoot performance bottlenecks in your databases. 若要了解见解小组件和数据库(以及服务器)仪表板,请参阅使用见解小组件管理服务器和数据库To learn about insight widgets, and database (and server) dashboards, see Manage servers and databases with insight widgets.

连接管理(服务器组)Connection management (server groups)

可以通过服务器组来组织所用服务器和数据库的连接信息。Server groups provide a way to organize connection information for the servers and databases you work with. 有关详细信息,请参阅服务器组For details, see Server groups.

集成的终端Integrated Terminal

使用你最喜爱的命令行工具 (例如 Bash、 PowerShell、 sqlcmd、 bcp 和 ssh 配合使用) 在集成终端窗口中右Azure Data StudioAzure Data Studio用户界面。Use your favorite command-line tools (for example, Bash, PowerShell, sqlcmd, bcp, and ssh) in the Integrated Terminal window right within the Azure Data StudioAzure Data Studio user interface. 若要了解有关集成终端的信息,请参阅集成的终端To learn about the integrated terminal, see Integrated terminal.

可扩展性和扩展创建Extensibility and extension authoring

增强Azure Data StudioAzure Data Studio通过扩展功能的基本安装体验。Enhance the Azure Data StudioAzure Data Studio experience by extending the functionality of the base installation. Azure Data StudioAzure Data Studio 数据管理活动,以及对扩展创建的支持,提供了扩展点。provides extensibility points for data management activities, as well as support for extension authoring.

若要了解有关中的可扩展性Azure Data StudioAzure Data Studio,请参阅扩展性To learn about extensibility in Azure Data StudioAzure Data Studio, see Extensibility. 若要了解有关创作扩展,请参阅扩展插件创作To learn about authoring extensions, see Extension authoring.

使用 SQL Server Management Studio (SSMS) 的功能比较Feature comparison with SQL Server Management Studio (SSMS)

如果使用 Azure Data Studio 您:Use Azure Data Studio if you:

  • 需要在 macOS 或 Linux 上运行Need to run on macOS or Linux
  • 要连接到 SQL Server 2019 大数据群集Are connecting to a SQL Server 2019 big data cluster
  • 花大部分时间编辑或执行查询Spend most of your time editing or executing queries
  • 需要快速图表和可视化结果集的能力Need the ability to quickly chart and visualize result sets
  • 可以执行大多数管理任务通过使用 sqlcmd 或 Powershell 集成终端Can execute most administrative tasks via the integrated terminal using sqlcmd or Powershell
  • 对向导体验的最小需求Have minimal need for wizard experiences
  • 不需要进行深度管理配置Do not need to do deep administrative configuration

如果使用 SQL Server Management Studio 您:Use SQL Server Management Studio if you:

  • 数据库管理任务上花费的大部分时间Spend most of your time on database administration tasks
  • 正在执行深度管理配置Are doing deep administrative configuration
  • 正在执行安全管理,包括用户管理、 漏洞评估和安全功能的配置Are doing security management, including user management, vulnerability assessment, and configuration of security features
  • 为 SQL Server Query Store 使用的报表Make use of the Reports for SQL Server Query Store
  • 需要进行性能优化顾问和仪表板的使用Need to make use of performance tuning advisors and dashboards
  • 正在执行的 Dacpac 导入/导出Are doing import/export of DACPACs
  • 需要已注册的服务器访问权限,而想要控制 SQL Server 在 Windows 上的服务Need access to Registered Servers and want to control SQL Server services on Windows

ShellShell

功能Feature Azure Data StudioAzure Data Studio SSMSSSMS
Azure 登录Azure Sign-In Yes Yes
面板Dashboard Yes
ExtensionsExtensions Yes
集成的终端Integrated Terminal Yes
“对象资源管理器”Object Explorer Yes Yes
对象脚本Object Scripting Yes Yes
项目系统Project System Yes
从表中选择Select from Table Yes Yes
源代码管理Source Code Control Yes
任务窗格Task Pane Yes
主题设置Theming Yes
深色模式Dark Mode Yes
Azure 资源浏览器Azure Resource Explorer 预览Preview
生成脚本向导Generate Scripts Wizard Yes
Import\Export DACPACImport\Export DACPAC Yes
对象属性Object Properties Yes
表设计器Table Designer Yes

查询编辑器Query Editor

功能Feature Azure Data StudioAzure Data Studio SSMSSSMS
图表查看器Chart Viewer Yes
将结果导出到 CSV、 JSON、 XLSXExport Results to CSV, JSON, XLSX Yes
IntelliSenseIntelliSense Yes Yes
代码段Snippets Yes Yes
显示计划Show Plan 预览Preview Yes
客户端统计信息Client Statistics Yes
实时查询统计信息Live Query Stats Yes
查询选项Query Options Yes
将结果保存到文件Results to File Yes
以文本格式显示结果Results to Text Yes
空间查看器Spatial Viewer Yes
SQLCMDSQLCMD Yes

操作系统支持Operating System Support

功能Feature Azure Data StudioAzure Data Studio SSMSSSMS
LinuxLinux Yes
macOSmacOS Yes
WindowsWindows Yes Yes

数据工程Data Engineering

功能Feature Azure Data StudioAzure Data Studio SSMSSSMS
创建外部表向导Create External Table Wizard 预览Preview
HDFS 的集成HDFS Integration 预览Preview
笔记本Notebooks 预览Preview

数据库管理Database Administration

功能Feature Azure Data StudioAzure Data Studio SSMSSSMS
备份/还原Backup / Restore Yes Yes
平面文件导入Flat File Import 预览Preview Yes
SQL 代理SQL Agent 预览Preview Yes
SQL ProfilerSQL Profiler 预览Preview Yes
AlwaysOnAlways On Yes
始终加密Always Encrypted Yes
复制数据向导Copy Data Wizard Yes
数据优化顾问Data Tuning Advisor Yes
错误日志查看器Error Log Viewer Yes
维护计划Maintenance Plans Yes
多服务器查询Multi-Server Query Yes
基于策略的管理Policy Based Management Yes
PolyBasePolyBase Yes
查询存储Query Store Yes
已注册的服务器Registered Servers Yes
ReplicationReplication Yes
安全管理Security Management Yes
Service BrokerService Broker Yes
SQL MailSQL Mail Yes
Template ExplorerTemplate Explorer Yes
漏洞评估Vulnerability Assessment Yes
XEvent 管理XEvent Management Yes

后续步骤Next steps

info_tip Get help for SQL tools

编辑内容 参与编辑 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.