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

Azure Data Studio 及其提供者的原始程式碼根據原始程式碼 EULA 提供在 GitHub 上,該合約提供修改和使用軟體的權限,但不能在雲端服務中進行重新散發或裝載。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 程式碼撰寫體驗,利用多個索引標籤視窗、豐富的 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. 使用智慧型程式碼片段,快速建立資料庫的複本以供進行開發或測試,以及產生和執行 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
  • 正在執行 DACPAC 的匯入/匯出Are 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
Always OnAlways 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
複寫Replication Yes
安全性管理Security Management Yes
Service BrokerService Broker Yes
SQL MailSQL Mail Yes
範本總管Template 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.