The point to note here is that Microsoft hasĭesigned both products for specific purposes, and there is no plan to deprecate the management studio. Sometimes, users ask this question whether we should use ADS or SSMS. When Should we use Azure Data Studio and SSMS?
This article explains upgrading SQL Server Management Studio (SSMS) and Azure Data Studio (ADS) to their latest version with a single installation.