什么是 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.

Azure Data Studio 以预览名称 SQL Operations 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.

可通过一个提供软件修改和使用权限的源代码 EULA 来获取 GitHub 上 Azure Data Studio 的源代码及其数据提供程序,但不能在云服务中重新分发或托管该源代码。The source code for Azure Data Studio and its data providers is available on GitHub under a source code EULA that provides rights to modify and use the software, but not to redistribute it or host it in a cloud service. 有关详细信息,请参阅 Azure Data Studio 常见问题解答For more information, see Azure Data Studio FAQ.

下载并安装 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 编辑器、IntelliSense、关键字完成、代码片段、代码导航和源代码管理集成 (Git))提供一种基于键盘的新式 SQL 编码体验,使日常任务变得更轻松。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. 使用智能代码片段快速创建数据库副本,以便进行开发或测试,并生成和执行 CREATE 和 INSERT 脚本。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

Azure Data StudioAzure Data Studio 用户界面的“集成终端”窗口中使用你最喜欢的命令行工具(例如,Bash、PowerShell、sqlcmd、bcp 和 ssh)。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 查询存储使用报表Make use of the Reports for SQL Server Query Store
  • 需要使用性能优化顾问和仪表板Need to make use of performance tuning advisors and dashboards
  • 要导入/导出 DACPACAre doing import/export of DACPACs
  • 需要访问已注册的服务器,并希望在 Windows 上控制 SQL Server 服务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
扩展项Extensions 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
导入\导出 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 获取 SQL 工具的帮助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.