Azure Data Studio is a data management and development tool with connectivity to popular cloud and on-premises databases. Azure Data Studio supports Windows, macOS, and Linux, with immediate capability to connect to Azure SQL and SQL Server. Browse the extension library for more database support options including MySQL, PostreSQL, and MongoDB.
Перейти к файлу
Lewis Sanchez 03b386a375
Speed up query results copying (#25866)
* Conditionally copy query results in backend

* Remote dep on remote hosts

* Remove changes

* Remove changes that caused slowdown

* Prefer copying from UI process

* Revert "Prefer copying from UI process"

This reverts commit 86d98492e8.

* Set prefer provider copy setting to false for linux

* Revert "Set prefer provider copy setting to false for linux"

This reverts commit 550d24e7e1.

* Default copy handling to UI for Linux

* Bump SqlOps-DataProtocolClient package to 2.0.1

* Bump STS Version to 5.0.20240912.2
2024-09-13 13:55:55 -07:00
.config Suppress cred scan issues (#23935) 2023-07-20 10:01:23 -07:00
.configurations Merge vscode source through release 1.79.2 (#23482) 2023-06-27 15:26:51 -07:00
.devcontainer Merge VS Code version 1.82 into Azure Data Studio (#24684) 2023-10-17 15:07:44 -07:00
.eslintplugin Update license to MIT (#24799) 2023-10-30 11:47:31 -04:00
.github Switch to intel based mac image (#25851) 2024-08-16 11:35:01 -07:00
.vscode Update license to MIT (#24799) 2023-10-30 11:47:31 -04:00
build Bump axios from 1.6.0 to 1.7.4 in /build/actions (#25840) 2024-08-15 18:39:42 -07:00
cli Bump openssl from 0.10.60 to 0.10.66 in /cli (#25764) 2024-07-24 12:55:23 -07:00
docs Revert "remove the docs folder (#9868)" (#9919) 2020-04-09 11:32:19 -07:00
extensions Speed up query results copying (#25866) 2024-09-13 13:55:55 -07:00
i18n Langpack update for May release (#25634) 2024-05-14 11:10:57 -07:00
remote Bump micromatch from 4.0.5 to 4.0.8 in /remote (#25869) 2024-08-26 11:04:31 -07:00
resources [Loc] updated XLFs for exthostModelView (#25795) 2024-07-29 15:32:07 -07:00
samples Bump braces from 2.3.2 to 3.0.3 in /samples/sqlservices (#25683) 2024-06-11 12:54:51 -07:00
scripts Remove "New Python Installation" option in Configure Python dialog (#25569) 2024-04-10 15:08:03 -07:00
src Speed up query results copying (#25866) 2024-09-13 13:55:55 -07:00
test Update electron to v25.9.8 (#25215) 2024-01-16 20:30:27 -08:00
.editorconfig Merge VS Code 1.31.1 (#4283) 2019-03-15 13:09:45 -07:00
.eslintignore Update license to MIT (#24799) 2023-10-30 11:47:31 -04:00
.eslintrc.json Update license to MIT (#24799) 2023-10-30 11:47:31 -04:00
.eslintrc.sql.ts.json check-param-names (#18189) 2022-01-31 12:39:22 -08:00
.git-blame-ignore Merge vscode source through release 1.79.2 (#23482) 2023-06-27 15:26:51 -07:00
.gitattributes Merge vscode source through 1.62 release (#19981) 2022-07-11 14:09:32 -07:00
.gitignore Merge VS Code version 1.82 into Azure Data Studio (#24684) 2023-10-17 15:07:44 -07:00
.lsifrc.json VS Code merge to df8fe74bd5 (#17979) 2022-01-06 09:06:56 -08:00
.mention-bot SQL Operations Studio Public Preview 1 (0.23) release source code 2017-11-09 14:30:27 -08:00
.nvmrc Merge VS Code version 1.82 into Azure Data Studio (#24684) 2023-10-17 15:07:44 -07:00
.yarnrc Update electron to v25.9.8 (#25215) 2024-01-16 20:30:27 -08:00
CHANGELOG.md update CHANGELOG for 1.49.0 release (#25800) 2024-08-01 16:30:03 -07:00
CONTRIBUTING.md Merge VS Code 1.31.1 (#4283) 2019-03-15 13:09:45 -07:00
CodeQL.yml Merge VS Code version 1.82 into Azure Data Studio (#24684) 2023-10-17 15:07:44 -07:00
LICENSE.txt Update license to MIT (#24799) 2023-10-30 11:47:31 -04:00
PRIVACY.md Update privacy documentation (#22520) 2023-03-29 15:40:01 -07:00
README.md Remove broken links to insider builds from readme (#25863) 2024-08-22 13:08:43 -07:00
SECURITY.md Merge VS Code version 1.82 into Azure Data Studio (#24684) 2023-10-17 15:07:44 -07:00
ThirdPartyNotices.txt Merge VS Code version 1.82 into Azure Data Studio (#24684) 2023-10-17 15:07:44 -07:00
azure-pipelines.yml Remove duplicate pipeline trigger (#17275) 2021-10-05 16:57:13 -07:00
cglicenses.json Merge VS Code version 1.82 into Azure Data Studio (#24684) 2023-10-17 15:07:44 -07:00
cgmanifest.json Update electron to v25.9.8 (#25215) 2024-01-16 20:30:27 -08:00
extensionsGallery.json Vscode merge (#4582) 2019-03-19 17:44:35 -07:00
gulpfile.js Update license to MIT (#24799) 2023-10-30 11:47:31 -04:00
package.json Bump webpack from 5.82.1 to 5.94.0 (#25877) 2024-09-03 16:41:45 -07:00
product.json Switch update logic to use Download Center based metadata links (#25677) 2024-06-10 18:59:09 -07:00
runlist.json Test run list proposal (#7617) 2019-10-18 17:21:40 -07:00
tsconfig.sql.json Start on new eslint file (#9314) 2020-02-26 11:39:00 -08:00
tsfmt.json Merge vscode source through 1.62 release (#19981) 2022-07-11 14:09:32 -07:00
yarn.lock Bump webpack from 5.82.1 to 5.94.0 (#25877) 2024-09-03 16:41:45 -07:00

README.md

Azure Data Studio

Join the chat at https://gitter.im/Microsoft/sqlopsstudio Build Status Twitter Follow

Azure Data Studio is a data management and development tool with connectivity to popular cloud and on-premises databases. Azure Data Studio supports Windows, macOS, and Linux, with immediate capability to connect to Azure SQL and SQL Server. Browse the extension library for additional database support options including MySQL, PostgreSQL, and MongoDB.

Download the latest Azure Data Studio release

Platform Type Download
Windows User Installer 64 bitARM
System Installer 64 bitARM
.zip 64 bitARM
Linux .tar.gz 64 bit
.deb 64 bit
.rpm 64 bit
Mac .zip UniversalIntel ChipApple Silicon

Go to our download page for more specific instructions.

Please visit our download page for more specific installation instructions. Check out the change log or release notes for additional details of what's in the each release. The Azure Data Studio documentation includes complete details on getting started, connection quickstarts, and feature tutorials.

Feature Highlights

  • Cross-Platform DB management for Windows, macOS and Linux with simple XCopy deployment
  • SQL Server Connection Management with Connection Dialog, Server Groups, Azure Integration and Registered Servers
  • Object Explorer supporting schema browsing and contextual command execution
  • T-SQL Query Editor with advanced coding features such as autosuggestions, error diagnostics, tooltips, formatting and peek definition
  • Query Results Viewer with advanced data grid supporting large result sets, export to JSON\CSV\Excel, query plan and charting
  • Management Dashboard supporting customizable widgets with drill-through actionable insights
  • Visual Data Editor that enables direct row insertion, update and deletion into tables
  • Backup and Restore dialogs that enables advanced customization and remote filesystem browsing, configured tasks can be executed or scripted
  • Task History window to view current task execution status, completion results with error messages and task T-SQL scripting
  • Scripting support to generate CREATE, SELECT, ALTER and DROP statements for database objects
  • Workspaces with full Git integration and Find In Files support to managing T-SQL script libraries
  • Modern light-weight shell with theming, user settings, full-screen support, integrated terminal and numerous other features

Here are some of these features in action.

Contributing

If you are interested in fixing issues and contributing directly to the code base, please see the document How to Contribute, which covers the following:

This project has adopted the Microsoft Open Source Code of Conduct. For more information see the Code of Conduct FAQ or contact opencode@microsoft.com with any additional questions or comments.

Localization

Azure Data Studio is localized into 10 languages: French, Italian, German, Spanish, Simplified Chinese, Traditional Chinese, Japanese, Korean, Russian, and Portuguese (Brazil). The language packs are available in the Extension Manager marketplace. Simply, search for the specific language using the extension marketplace and install. Once you install the selected language, Azure Data Studio will prompt you to restart with the new language.

Telemetry

Azure Data Studio collects telemetry data, which is used to help understand how to improve the product. For example, this usage data helps to debug issues, such as slow start-up times, and to prioritize new features. While we appreciate the insights this data provides, we also know that not everyone wants to send usage data and you can disable telemetry as described in the disable telemetry reporting documentation.

Privacy Statement

The Microsoft Privacy Statement describes the privacy statement of this software.

Contributions and "Thank You"

We would like to thank all our users who raised issues, and in particular the following users who helped contribute fixes:

  • eulercamposbarros for Prevent connections from moving on click (#7528)
  • AlexFsmn for Fixed issue where task icons got hidden if text was too long
  • jamesrod817 for Tempdb (#7022)
  • dzsquared for fix(snippets): ads parenthesis to sqlcreateindex snippet #7020
  • devmattrick for Update row count as updates are received #6642
  • mottykohn for In Message panel onclick scroll to line #6417
  • Stevoni for Corrected Keyboard Shortcut Execution Issue #5480
  • yamatoya for fix the format #4899
  • GeoffYoung for Fix sqlDropColumn description #4422
  • AlexFsmn for Added context menu for DBs in explorer view to backup & restore db. #2277
  • sadedil for Missing feature request: Save as XML #3729
  • gbritton1 for Removed reference to object explorer #3463
  • Tarig0 for Add Routine_Type to CreateStoredProc fixes #3257 (#3286)
  • oltruong for typo fix #3025'
  • Thomas-S-B for Removed unnecessary IErrorDetectionStrategy #749
  • Thomas-S-B for Simplified code #750
  • rdaniels6813 for Add query plan theme support #3031
  • Ruturaj123 for Fixed some typos and grammatical errors #3027
  • PromoFaux for Use emoji shortcodes in CONTRIBUTING.md instead of <20> #3009
  • ckaczor for Fix: DATETIMEOFFSET data types should be ISO formatted #714
  • hi-im-T0dd for Fixed sync issue with my forked master so this commit is correct #2948
  • hi-im-T0dd for Fixed when right clicking and selecting Manage-correct name displays #2794
  • philoushka for center the icon #2760
  • anthonypants for Typo #2775
  • kstolte for Fix Invalid Configuration in Launch.json #2789
  • kstolte for Fixing a reference to SQL Ops Studio #2788
  • AlexFsmn Feature: Ability to add connection name #2332
  • AlexFsmn Disabled connection name input when connecting to a server. #2566
  • SebastianPfliegel Added more saveAsCsv options #2099
  • ianychoi Fixes a typo: Mimunum -> Minimum #1994
  • AlexFsmn Fixed bug where proper file extension wasn't appended to the filename. #2151
  • AlexFsmn Added functionality for adding any file to import wizard #2329
  • AlexFsmn Fixed background issue when copying a chart to clipboard #2215
  • AlexFsmn Fixed problem where vertical charts didn't display labels correctly. #2263
  • AlexFsmn Fixed Initial values for charts to match visuals #2266
  • AlexFsmn Renamed chart option labels #2264
  • AlexFsmn Added feature for the opening file after exporting to CSV/XLS/JSON & query files #2216
  • AlexFsmm Get Connection String should copy to clipboard #2175
  • lanceklinger Fix for double-clicking column handle in results table #1504
  • westerncj for Removed duplicate contribution from README.md (#753)
  • ntovas for Fix for duplicate extensions shown in "Save File" dialog. (#779)
  • SebastianPfliegel for Add cursor snippet (#475)
  • mikaoelitiana for the fix: revert README and CONTRIBUTING after last VSCode merge (#574)
  • alextercete for Reinstate menu item to install from VSIX (#682)
  • alextercete for Fix "No extension gallery service configured" error (#427)
  • mwiedemeyer for Fix #58: Default sort order for DB size widget (#111)
  • AlexTroshkin for Show disconnect in context menu only when connectionProfile connected (#150)
  • AlexTroshkin for Fix #138: Invalid syntax color highlighting (identity not highlighting) (#140))
  • stebet for Fix #153: Fixing sql snippets that failed on a DB with a case-sensitive collation. (#152)
  • SebastianPfliegel Remove sqlExtensionHelp (#312)
  • olljanat for Implemented npm version check (#314)
  • Adam Machanic for helping with the whoisactive extension

And of course, we'd like to thank the authors of all upstream dependencies. Please see a full list in the ThirdPartyNotices.txt

License

Copyright (c) Microsoft Corporation. All rights reserved.

Licensed under the MIT License.