But you need SSMS on a Windows client to manage it effectively. Unless you are doing everything cli, which is just not practical in the enterprise. Anyway, running it in Linux is pretty niche. Cool for show and tell, but you need balls of steel if you're going to try running even a small $100 million dollar business on it.
Last I checked, Azure data studio did not have feature parity with SSMS. Sure you can write TSQL, view and edit procedures. But that’s about where it ends.
You can’t deploy SSIS packages, can’t edit user accounts and permissions, can’t manage linked servers, etc. Sure you might not do those every day, but if you have to jump through all these hoops to do something I wouldn’t call ADS a full replacement.
ADS can't really do this, as others have mentioned. Years in the future, they will get there. It's not remotely capable yet. And even many of the dialogue boxes that they've added recently are just opening in SSMS which still requires Windows.
