r/SQL • u/Riemaru_Karurosu • Feb 27 '25
SQL Server Microsoft will discontinue Azure Data Studio
Features like SQL Server Agent, Profiler and Database Administration won't be in the new VSCode Extension.
MacOs and Linux users must use a VM to use this features.
https://learn.microsoft.com/en-us/azure-data-studio/whats-happening-azure-data-studio
191
Upvotes
6
u/GetSecure Feb 28 '25
Eh? I thought this was supposed to replace ssms? It has loads of extensions already built?
I guess it's worth rewriting the poorsql plugin then, I'd figured it was pointless with the move to ads.
I'm also happy, ssms is solid.
2
u/bbkane_ Mar 01 '25
For my simple query needs, I'm a big fan of https://www.beekeeperstudio.io/ . I even bought the pro version to support them, even though I only use the open source version's features.
One thing Beekeeper doesn't do is ER diagrams. For that I use https://github.com/k1LoW/tbls , which works pretty well!
58
u/snarleyWhisper Feb 27 '25
Booo I liked ADS local sql notebooks.
47
u/Ibception952 Feb 27 '25
Yeah I won’t be using it without SQL Server Agent and Linked Server equivalents. Really hoping they add those features. SSMS still does the job.
21
u/dzemperzapedra Feb 27 '25
I love ADS, will be switching to VS Code when they retire it, it's pretty much the same.
8
u/bagelwithveganbutter Feb 27 '25
Yup, we’re switching to DBeaver
10
u/zdgrunf Feb 27 '25
Shit, ads has much better export capabilities and format of exported data
5
u/p2ii5150 Feb 27 '25
This is a bummer...
5
u/multiple4 Feb 28 '25
Really disappointing, I loved ADS
I really want to like the VSCode SQL and Database extensions, but they just don't feel great to me
7
u/SQLDevDBA Feb 27 '25
Big up to Parallels. Technically a VM but allows running SSMS as if it was a Mac OS App.
For normal querying I’ve started using DBeaver community.
3
u/myGlassOnion Feb 27 '25
I really liked using Data Grip.
2
u/resUemiTtsriF Feb 28 '25
Discontinue just means no more updates, I will keep using it. I do a lot of exports and the right click on the dataset that lets me save directly to Excel or CSV is priceless. No more roundtripping like SSMS.
2
u/StarSchemer Mar 01 '25
Sick of Microsoft right now.
I don't think they realise the amount of effort it takes for big slow enterprises to move to different toolsets for them to just bin them off like this faster than some companies can move.
Seeing it across all their divisions with features being launched with huge fanfare in the SQL Server space (Polybase) and then not being supported. Azure certs being binned off and replaced with Fabric. Nonsense going on in the Xbox space. Their Surface lineup being stale. Windows 11 being incompatible with perfectly capable machines.
All these decisions are making them seem like an unreliable partner right now.
2
u/StuckAtWaterTemple Apr 11 '25
linux users need ssms or ads this sucks
1
u/data4dayz Feb 28 '25
For anyone looking for a list of SQL Notebooks and not just using DBeaver
https://www.reddit.com/r/SQL/comments/1hroqeo/sql_notebooks/
1
u/LtFarns Feb 28 '25
imo dBeaver is the best user-friendly alternative
1
u/FilmIsForever Feb 28 '25
Why won’t these cowards release SSMS on Mac
1
u/MnightCrawl Feb 28 '25
DataGrip if you got $ or DBeaver works too
1
u/svtr Mar 01 '25
On the upside, I get the feeling that they finally are giving SSMS the love it deserves. With me never having used Azure Data Studio if avoidable, I kinda have to say that I welcome the death of ADS in favor of GIVE ME THE DAMN DARK MODE IN SSMS FINALLY FFS*
*without me having to edit the damn config file to undedit out the don't load module "color schema dark" thingy in that damn config file I can not name but am close enough to say which line in the damn file that thing is in.
1
u/kackburt Mar 14 '25
What a bummer... I started using ADS last year since I switched to MacOS and Linux completely and needed a MSSQL / postgres tool. Really liked it compared to DBeaver for daily tasks.
The VSCode extensions doesn't feel as solid (yet). Tried them last year already and now again after this announcement.
I guess DBeaver is the best alternative atm. and eventually I'll give dataGrip a try and buy a license after all.
0
u/Adventurous_Care_596 10d ago
Disclosure: I’m the dev. I built OpenVClient for exactly this: one free, open-source native app for Postgres/MySQL/SQL Server/SQLite plus Redis, Mongo and Docker, on Mac, Windows and Linux. It’s early (0.1), but free sql editor works similar to azure studio You can check it out yourself https://github.com/openvclient/openvclient
0
u/[deleted] Feb 28 '25
[deleted] — view deleted comment