azuredatastudio

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, PostgreSQL, and MongoDB.

MIT License

Downloads
78
Stars
7.5K
Committers
183
View Code on GitHub Visit Website View on X
Ecosystems: Electron, PostgreSQL, TypeScript, sql-server, Azure

Bot releases are hidden (Show)

azuredatastudio - November 2022 Release (version 1.40.0)

Published by erpett almost 2 years ago

Version 1.40.0

  • Release date: November 16, 2022
  • Release status: General Availability

What's new in 1.40.0

New Item Details
Connections Connections for SQL now default to Encrypt = 'True'.
ARM64 Support for macOS ARM64 build for macOS is now available.
Table Designer Announcing the General Availability of the Table Designer.
Table Designer Period columns now added by default when System-Versioning table option is selected.
Table Designer Added support for hash indexes for In-Memory tables, and added support for columnstore indexes.
Table Designer New checkbox added, "Preview Database Updates", when making database changes to ensure that users are aware of potential risks prior to updating the database.
Table Designer "Move Up" and "Move Down" buttons added to support column reordering for Primary Keys.
Query Plan Viewer Announcing the General Availability of the Query Plan Viewer in Azure Data Studio.
Query Plan Viewer Added support for identification of most expensive operator(s) in a plan.
Query Plan Viewer Updates were made to the properties window to allow for full display of text upon hovering over a cell. Full text can also be copied.
Query Plan Viewer Implemented filter functionality in the Properties pane for an execution plan.
Query Plan Viewer Added support for collapsing and expanding all subcategories within the Plan Comparison Properties window.
Query History Extension Announcing the General Availability of the SQL History Extension.
Query History Extension Now includes ability to persist history across multiple user sessions.
Query History Extension Added the ability to limit the number of entries stored in the history.
Schema Compare Users can now open .scmp files directly from the context menu for existing files in the file explorer.
Query Editor Now allows full display for text strings larger than 65,535 characters.
Query Editor Added support for the SHIFT key when making multiple cell selections.
MySQL Extension Support for MySQL extension is now available in preview.
Azure SQL Migration Extension Azure SQL Database Offline Migrations is now available in preview. Customers can use this new capability to save and share reports as needed.
Azure SQL Migration Extension Addition of elastic Azure recommendations model.
Database Migration Assessment for Oracle Assessment tooling for Oracle database migrations to Azure Database for PostgreSQL and Azure SQL available in preview.
VS Code merge VS Code merges to version 1.67. Read their release notes to learn more.
SQL Database Projects Adds SQL projects support for syntax introduced in SQL Server 2022.

Bug fixes in 1.40.0

New Item Details
Connections Fixed bug that occurred when trying to connect to the Dedicated Admin Connection (DAC) on SQL Server.
Connections Fixed issue with wrong tenant showing up while trying to connect to a database with Azure Active Directory login.
Connections Fixed zoom reset behavior when adding a new connection.
Connections Fixed loading bug what occurred when attempting to sign in to Azure via proxy.
Connections Fixed issue encountered while attempting to connect to a "sleeping" Azure SQL Database.
Object Explorer Fixed the SELECT script generation issue for Synapse Databases.
Schema Compare Fixed error that caused duplication of comment headers when applying schema changes on stored procedure objects.
Schema Compare Fixed issue that prevented schema compare issues when creating a new empty schema with a "DOMAIN\User" pattern.
Query Editor Fixed bug that caused results to be lost upon saving query files.
Table Designer Fixed a bug that caused creation of a new table when renaming an existing table.
Query Plan Viewer Fixed missing index recommendation T-SQL syntax.
SQL Projects Fixed bug in SQL Projects that led to extension not using output path when publishing a project.
SQL Projects Fixed bug that caused .NET install to not be found when using the SQL Projects extension on Linux platforms.
Platform
Windows User Installer
Windows System Installer
Windows ZIP
macOS Universal
macOS ZIP
macOS ZIP
Linux TAR.GZ
Linux RPM
Linux DEB
azuredatastudio - August 2022 Release Hotfix 1 (version 1.39.1)

Published by kburtram about 2 years ago

Version 1.39.1

  • Release date: August 30, 2022
  • Release status: General Availability

What's new in 1.39.1

  • Bug fixes in 1.39.1
    • Fixed bug that caused Database Trees in server connections to not expand in the Object Explorer.
Platform
Windows User Installer
Windows System Installer
Windows ZIP
macOS ZIP
Linux TAR.GZ
Linux RPM
Linux DEB
azuredatastudio - August 2022 Release (version 1.39.0)

Published by erpett about 2 years ago

Version 1.39.0

  • Release date: August 24, 2022
  • Release status: General Availability

What's new in 1.39.0

New Item Details
Deployment Wizard Azure Data Studio now supports SQL Server 2022 (Preview) in the Deployment Wizard for both local and container installation.
Object Explorer Added Ledger icons and scripting support to Object Explorer for Ledger objects.
Dashboard Added hexadecimal values to support color detection.
Query Plan Viewer Added the ability to copy text from cells in the Properties Pane of a query plan.
Query Plan Viewer Introduced a "find node" option in plan comparison to search for nodes in either the original or added plan.
Table Designer Now supports the ability to add included columns to a nonclustered index, and the ability to create filtered indexes.
SQL Projects Publish options were added to the Publish Dialog.
Query History Extension Added double-click support for query history to either open the query or immediately execute it, based on user configuration.

Bug fixes in 1.39.0

New Item Details
Dashboard Fixed an accessibility issue that prevented users from being able to access tooltip information using the keyboard.
Voiceover Fixed a bug that caused voiceover errors across the Dashboard, SQL Projects, SQL Import Wizard, and SQL Migration extensions.
Schema Compare Fixed a bug that caused the UI to jump back to the top of the options list after selecting/deselecting any option.
Schema Compare Fixed a bug involving Schema Compare (.SCMP) file incompatibility with Database Project information causing errors when reading and using information stored in this file type.
Object Explorer Fixed a bug that caused menu items in Object Explorer not to show up for non-English languages.
Table Designer Fixed a bug that caused the History Table name not to be consistent with the current table name when working with System-Versioned Tables.
Table Designer Fixed a bug in the Primary Key settings that caused the "Allow Nulls" option to be checked, but disabled, preventing users from changing this option.
Query Editor Fixed a bug that prevented the SQLCMD in T-SQL from working correctly, giving false errors when running scripts in Azure Data Studio.
Query Editor Fixed a bug that caused user-specified zoom settings to reset to default when selecting JSON values after query that returned JSON dataset was ran.
SQL Projects Fixed a bug that caused the "Generate Script" command to not work correctly when targeting a new Azure SQL Database.
Notebooks Fixed a bug that caused pasted images to disappear from editor after going out of edit mode.
Notebooks Fixed a bug that caused a console error message to appear after opening a markdown file.
Notebooks Fixed a bug that prevented markdown cell toolbar shortcuts from working after creating a new split view cell.
Notebooks Fixed a bug that caused text cells to be erroneously created in split view mode when the notebook default text edit mode was set to "Markdown".
Platform
Windows User Installer
Windows System Installer
Windows ZIP
macOS ZIP
Linux TAR.GZ
Linux RPM
Linux DEB
azuredatastudio - July 2022 Release (version 1.38.0)

Published by erpett about 2 years ago

Version 1.38.0

  • Release date: July 27, 2022
  • Release status: General Availability

What's new in 1.38.0

New Item Details
VS Code merges to 1.62 This release includes updates to VS Code from the three previous VS Code releases. Read their release notes to learn more.
Table Designer New column added to Table Designer for easier access to additional actions specific to individual rows.
Query Plan Viewer The Top Operations pane view now includes clickable links to operations in each of its rows to show the runtime statistics which can be used to evaluate estimated and actual rows when analyzing a plan.
Query Plan Viewer Improved UI on selected operation node in the Execution Plan.
Query Plan Viewer The keyboard command CTRL + M no longer executes queries. It now just enables or disables the actual execution plan creation when a query is executed.
Query Plan Viewer Plan labels are now updated in the Properties window when plans are compared and the orientation is toggled from horizontal to vertical, and back.
Query Plan Viewer Updates were made to the Command Palette. All execution plan commands are prefixed with "Execution Plan", so that they are easier to find and use.
Query Plan Viewer A collapse/expand functionality is now available at the operator level to allow users to hide or display sections of the plan during analysis.
Query History The Query History extension was refactored to be fully implemented in an extension. This makes the history view behave like all other extension views and also allows for searching and filtering in the view by selecting the view and typing in your search text.

Bug fixes in 1.38.0

New Item Details
Table Designer Error found in edit data tab when switching back to previously selected column when adding a new row. To fix this, editing the table is now disabled while new rows are being added and only reenabled afterwards.
Query Editor Fixed coloring issues for new T-SQL functions in the Query Editor.
Query Plan Viewer Fixed bug that caused custom zoom level spinner to allow values outside valid range.
Dashboard Fixed issue that caused incorrect displaying of insight widgets on the dashboard.
Notebooks Fixed issue where keyboard shortcuts and toolbar buttons were not working when first creating a Split View markdown cell.
Notebooks Fixed issue where cell languages were not being set correctly when opening an ADS .NET Interactive notebook in VS Code.
Notebooks Fixed issue where notebook was being opened as empty when exporting a SQL query as a notebook.
Notebooks Disables install and uninstall buttons in Manage Packages dialog while a package is being installed or uninstalled.
Notebooks Fixed issue where cell toolbar buttons were not refreshing when converting cell type.
Notebooks Fixed issue where notebook was not opening if a cell contains an unsupported output type.
Schema Compare Fixed issue where views and stored procedures were not correctly recognized by schema compare after applying changes.
Platform
Windows User Installer
Windows System Installer
Windows ZIP
macOS ZIP
Linux TAR.GZ
Linux RPM
Linux DEB
azuredatastudio - June 2022 Release (version 1.37.0)

Published by erpett over 2 years ago

Version 1.37.0

  • Release date: June 15, 2022
  • Release status: General Availability

What's new in this version

  • New Features:

    • Backup & Restore - Backup & Restore to URL is now available in preview for Azure SQL Managed Instances.
    • Table Designer - Added API to support computed column capabilities on Table Designer.
    • Table Designer - Can now specify where to add new columns and columns can now be re-arranged by mouse dragging.
    • Table Designer - Table Designer is now supported by SQL Projects to add or modify database schema without need to be connected to a server instance.
    • Query Plan Viewer - Smart plan comparison is now available. Can now compare execution plans and view detailed differences between plans in the Properties Table.
    • Query Plan Viewer - Added toggle button to switch between estimated and actual execution plans.
    • Query Plan Viewer - Query Plan now comes with improved precision to operator costs for larger plans.
    • MongoDB Extension for Azure Cosmos DB (Preview) - This extension introduces support for access to Mongo resources for Cosmos DB.

  • Bug Fixes:

    • Table Designer - Fixed issue that caused app to not prompt user to save before closing.
    • Table Designer - Fixed issue that returned empty data set upon attempting to edit the first cell of a new row.
    • Table Designer - Improved resize to fit experience when zooming in on user interface as well as tab behavior issues.
    • Query Plan Viewer - Fixed bug that caused custom zoom level spinner to allow values outside valid range.
    • Schema Compare - Fixed issue with indexes not being added correctly when updating project from database.
    • Notebooks - Fixed inconsistencies with notebook cell behavior and toolbars.
    • Notebooks - Fixed issues with keyboard navigation.
Platform
Windows User Installer
Windows System Installer
Windows ZIP
macOS ZIP
Linux TAR.GZ
Linux RPM
Linux DEB
azuredatastudio - April 2022 Release Hotfix 2 (version 1.36.2)

Published by erpett over 2 years ago

Version 1.36.2

  • Release date: May 20, 2022
  • Release status: General Availability

What's new in this version

  • Fixed issue with execution plan zoom and operator icons
  • Updated parallelism icon direction
Platform
Windows User Installer
Windows System Installer
Windows ZIP
macOS ZIP
Linux TAR.GZ
Linux RPM
Linux DEB
azuredatastudio - April 2022 Release Hotfix 1 (version 1.36.1)

Published by erpett over 2 years ago

Version 1.36.1

  • Release date: April 22, 2022
  • Release status: General Availability

What's new in this version

Platform
Windows User Installer
Windows System Installer
Windows ZIP
macOS ZIP
Linux TAR.GZ
Linux RPM
Linux DEB
azuredatastudio - April 2022 Release (version 1.36.0)

Published by erpett over 2 years ago

Version 1.36.0

  • Release date: April 20, 2022
  • Release status: General Availability

What's new in this version

  • General Availability of the Azure SQL Migration Extension for ADS
  • Support for .NET Interactive Notebooks Extension
  • New Table Designer Features including support for System Versioned, Graph and Memory Optomized Tables
  • Query Plan Viewer Updates includign warning and parallelism icons, the option to disable tooltips and support for opening .sqlplan files
  • Improvements in SQL Projects and Schema Compare
Platform
Windows User Installer
Windows System Installer
Windows ZIP
macOS ZIP
Linux TAR.GZ
Linux RPM
Linux DEB
azuredatastudio - February 2022 Release Hotfix 1 (version 1.35.1)

Published by erpett over 2 years ago

Version 1.35.1

  • Release date: March 17, 2022
  • Release status: General Availability

Hotfix release

Platform
Windows User Installer
Windows System Installer
Windows ZIP
macOS ZIP
Linux TAR.GZ
Linux RPM
Linux DEB
azuredatastudio - February 2022 Release (version 1.35.0)

Published by erpett over 2 years ago

Version 1.35.0

  • Release date: February 24, 2022
  • Release status: General Availability

What's new in this version

  • New Features:

    • Table Designer - Added functionality for creation and management of tables for SQL Servers. Built using DacFx framework
    • Query Plan Viewer - Added functionality for users to view a graphic view of estimated and actual query plans without need for an extension
    • Azure Arc Extension - Updated the Data Controller deployment wizard and the SQL Managed Instance - Azure Arc deployment wizard to reflect the deployment experience in Azure Portal

  • Bug Fixes:

    • Azure Arc Extension - SQL Managed Instance-Azure Arc is now fixed for both indirect connectivity mode and direct connectivity mode
    • Notebooks - Support for keyboard navigation between cells to minimize mouse clicking
Platform
Windows User Installer
Windows System Installer
Windows ZIP
macOS ZIP
Linux TAR.GZ
Linux RPM
Linux DEB
azuredatastudio - December 2021 Release (version 1.34.0)

Published by alanrenmsft almost 3 years ago

Version 1.34.0

  • Release date: December 15, 2021
  • Release status: General Availability

What's new in this version

  • New Features:

    • Added “Currently restoring backup file” in the migration progress details page of Azure SQL Migration extension when backup files location is Azure Storage blob container
    • Enhancements to diagnostics in Azure SQL Migration extension
    • Support for project build with .NET 6 in SQL Database Projects extension
    • Publish to container in SQL Database Projects extension
    • Undo and redo support for notebook cell-level operations

  • Extension Updates:

    • Azure SQL Migration
    • Langpacks
    • SQL Database Projects

  • Bug Fixes:

    • Fix for multiple database migrations when using network share as backup files location in Azure SQL Migration extension
    • Fix for multiple database migrations when using blob storage containers as backup files location in Azure SQL Migration extension
    • Fix to pre-populate target database names in the migration wizard in Azure SQL Migration extension
    • Fix to column sorting in grids where the presence of null values could lead to unexpected results
    • Fix for Python upgrades when two or more notebooks were open
Platform
Windows User Installer
Windows System Installer
Windows ZIP
macOS ZIP
Linux TAR.GZ
Linux RPM
Linux DEB
azuredatastudio - October 2021 Release Hotfix 1 (version 1.33.1)

Published by v-srinisa almost 3 years ago

Version 1.33.1

  • Release date: Nov 4, 2021
  • Release status: General Availability

Hotfix release

Platform
Windows User Installer
Windows System Installer
Windows ZIP
macOS ZIP
Linux TAR.GZ
Linux RPM
Linux DEB
azuredatastudio - October 2021 Release (version 1.33.0)

Published by chayaverma7 almost 3 years ago

Version 1.33.0

  • Release date: October 27, 2021
  • Release status: General Availability

What's new in this version

  • New Notebook Features:

    • Notebook Views
    • Split cell support
    • Keyboard shortcuts for Markdown Toolbar Cells
      • Ctrl/Cmd + B = Bold Text
      • Ctrl/Cmd + I = Italicize Text
      • Ctrl/Cmd + U = Underline Text
      • Ctrl/Cmd + Shift + K = Add Code Block
      • Ctrl/Cmd + Shift + H = Highlight Text
    • Book improvements
      • Add a new section
      • Drag and Drop

  • Extension Updates:

    • Import
    • Langpacks
    • Schema Compare
    • Sql Database Projects
    • Azure SQL Migration

  • Bug Fixes

    • Notebook linking improvements
    • Horizontal Scrollbar improvement (when word wrap is off in MD Splitview / MD mode) in Notebooks
    • Vertical Scrollbar improvement for MD Splitview in Notebooks
Platform
Windows User Installer
Windows System Installer
Windows ZIP
macOS ZIP
Linux TAR.GZ
Linux RPM
Linux DEB
azuredatastudio - August 2021 Release (version 1.32.0)

Published by chayaverma7 about 3 years ago

Version 1.32.0

  • Release date: August 18 , 2021
  • Release status: General Availability

What's new in this version

  • Extension Updates:
    • Arc/Az CLI extensions - Azure Arc extension now uses Azure CLI instead of Azure Data CLI for deploying and interacting with Azure Arc instances
    • Azure Monitor
    • Langpacks
    • SQL Database Projects
    • Machine Learning
Platform
Windows User Installer
Windows System Installer
Windows ZIP
macOS ZIP
Linux TAR.GZ
Linux RPM
Linux DEB
azuredatastudio - July 2021 Release Hotfix 1 (version 1.31.1)

Published by chayaverma7 about 3 years ago

Version 1.31.1

  • Release date: July 29, 2021
  • Release status: General Availability

Hotfix release

What's new in this version

  • New Notebook Features:
    • WYSIWYG link improvements
  • Extension Updates:
    • Import
    • SandDance
    • SQL Database Projects
  • Bug Fixes
    • Accessibility bug fixes
    • Fix SQL/Notebook editors opening as plaintext
Platform
Windows User Installer
Windows System Installer
Windows ZIP
macOS ZIP
Linux TAR.GZ
Linux RPM
Linux DEB
azuredatastudio - July 2021 Release (version 1.31.0)

Published by chayaverma7 about 3 years ago

Version 1.31.0

  • Release date: July 21 2021
  • Release status: General Availability

What's new in this version

  • New Notebook Features:
    • WYSIWYG link improvements
  • Extension Updates:
    • Import
    • SandDance
    • SQL Database Projects
  • Bug Fixes
    • Accessibility bug fixes
Platform
Windows User Installer
Windows System Installer
Windows ZIP
macOS ZIP
Linux TAR.GZ
Linux RPM
Linux DEB
azuredatastudio - June 2021 Release (version 1.30.0)

Published by chayaverma7 over 3 years ago

Version 1.30.0

  • Release date: June 17 2021
  • Release status: General Availability

What's new in this version

  • New Notebook Features:
    • Show book's notebook TOC title in pinned notebooks view
    • Add new book icon
    • Update Python to 3.8.10
  • Query Editor Features:
    • Added filtering/sorting feature for query result grid in query editor and notebook, the feature can be invoked from the column headers.
      Note that this feature is only available when you enable the preview features
    • Added a status bar item to show summary of the selected cells if there are multiple numeric values
  • Extension Updates:
    • SQL Database Projects
    • Machine Learning
  • Bug Fixes
    • Fix WYSIWYG Table cell adding new line in table cell
Platform
Windows User Installer
Windows System Installer
Windows ZIP
macOS ZIP
Linux TAR.GZ
Linux RPM
Linux DEB
azuredatastudio - May 2021 Release (version 1.29.0)

Published by alanrenmsft over 3 years ago

Version 1.29.0

  • Release date: May 19 2021
  • Release status: General Availability
  • New Notebook Features
    • Added run with parameters action. Learn more here
  • Extension Updates:
    • SQL Database Projects
    • Schema Compare
  • Bug Fixes

What's new in this version

Platform
Windows User Installer
Windows System Installer
Windows ZIP
macOS ZIP
Linux TAR.GZ
Linux RPM
Linux DEB
azuredatastudio - April 2021 Release (version 1.28.0)

Published by abist over 3 years ago

Version 1.28.0

  • Release date: April 14, 2021
  • Release status: General Availability
  • New Notebook Features:
    • Added Add Notebook and Remove Notebook commands
  • Extension Updates:
    • SQL Database Projects
    • Schema Compare
  • Bug Fixes

What's new in this version

Platform
Windows User Installer
Windows System Installer
Windows ZIP
macOS ZIP
Linux TAR.GZ
Linux RPM
Linux DEB
azuredatastudio - March 2021 Release (version 1.27.0)

Published by cssuh over 3 years ago

Version 1.27.0

  • Release date: March 17, 2021
  • Release status: General Availability
  • New Notebook Features:
    • Added create book dialog
  • Extension Updates:
    • Import
    • Dacpac
    • Machine Learning
    • SQL Assessment
    • Arc
    • SQL Database Projects
    • ASDE Deployment
  • Bug Fixes

What's new in this version

Platform
Windows User Installer
Windows System Installer
Windows ZIP
macOS ZIP
Linux TAR.GZ
Linux RPM
Linux DEB
Package Rankings
Top 3.74% on Proxy.golang.org
Top 5.71% on Npmjs.org
Badges
Extracted from project README
Join the chat at https://gitter.im/Microsoft/sqlopsstudio Build Status Twitter Follow
Related Projects
vscode-sqltools

Database management for VSCode

15 Dec 2016 1,487
vscode-cosmosdb

Azure Databases extension for VS Code

14 Aug 2017 156