

The early iterations of ADS targeted SQL Server specifically. If the acknowledgment or awareness of ADS from SSMS users has been lacking, this will likely change since starting with the release of SSMS (18.7.1 on October 27, 2020), ADS was included with the SSMS installation and installed alongside SSMS. For avid users of SSMS, ADS may not look like much of a competitor however, there are some features unique to ADS that even ardent users of SSMS will come to appreciate.
Azure data studio vs ssms code#
ADS is a downstream fork of VS Code and is merged regularly. While relatively new, ADS is starting to mature into a quality addition to cross-platform tooling following closely in the footsteps of its cousin, Visual Studio Code. With the general availability release launched in September 2018, the product was renamed to what we know today as Azure Data Studio.

Launched as an open-source initiative, ADS first appeared as “SQL Operations Studio” with pre-release public previews being available in late 2017. While the strong feature set and robust capabilities have helped DBAs and developers alike for the better part of 15 years, there remained a need for a cross-platform solution to allow additional accessibility to a new generation of developers, database administrators, data analysts, and data architects alike.Įnter Azure Data Studio (ADS). SQL Server Management Studio (SSMS) has been a mainstay of the SQL Server ecosystem as far back as SQL Server 2005.
