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

Azure Data Studio 是跨平台資料庫工具,供資料專業人員使用 Microsoft 家族的內部部署和雲端資料平台,在 Windows、 MacOS 和 Linux 上的。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. 使用智慧程式碼片段快速建立資料庫副本以進行開發或測試,並生成和執行 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. 若要深入了解 insight widget 和資料庫 (和伺服器)的儀表板,請參閱透過 insight widget 管理伺服器和資料庫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
  • 需要存取已註冊的伺服器和想要控制 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
延伸模組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
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
視窗Windows 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
Tuning Advisor 的資料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 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.