3 ms·

Microsoft SQL Server runs on Linux and Windows.

• trimethylpurine 3y ago
  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.
  • borissk 3y ago
    https://learn.microsoft.com/en-us/sql/azure-data-studio/download-azure-data-studio?view=sql-server-ver16&tabs=redhat-install%2Credhat-uninstall https://learn.microsoft.com/en-us/sql/azure-data-studio/down... It's fully supported by Microsoft on Linux, so if you run into technical problems you have a support line to call.
    • SamuelAdams 3y ago
      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.
    • trimethylpurine 3y ago
      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.