5 ms·

I doubt any of those 100.000.000.000 commercial products that need MSSQL would run on Linux either. In fact, even SQL Server Management Studio is a Windows-onl

I doubt any of those 100.000.000.000 commercial products that need MSSQL would run on Linux either. In fact, even SQL Server Management Studio is a Windows-only application.

pmelendez 10y ago
They don't have to. Let's say an enterprise wants to go start moving its backend to the cloud. Now there is a very significant price difference between windows instances and Linux instances. The client commercial product can still run on Windows and the database in Linux
- tracker1 10y ago
  For that matter, it's been surprisingly easy to get ASP.Net apps to run with mono or .net core in some cases. ymmv of course, and the performance will vary, but it's an option.
dogma1138 10y ago
Actually a lot of them do it's not hard to find some ticketing system or a call center management system that is written in JAVA or PHP and only works with mssql or oracle dbms. The app stack is usually more platform agnostic than you think. Even if it's asp.net you most likely going to be able to run it or easily port it to .net core. Basically having cross platform .net is pointless without having cross platform everything else especially MSSQL.
- tracker1 10y ago
  I was surprised how easy it was to get a couple asp.net apps running under docker dotnet-onbuild base containers... I think having SQL Server under linux/docker is a really nice option. Just being able to use it with ci/cd environments in linux is a pretty big thing. I've moved more away from the MS environments the past few years now, but have missed some of the things that MSSQL makes very easy, and by comparison PostgreSQL makes relatively hard. Of course you're paying for it. Having the option to run under Linux is really nice though imho.
  - insulanian 10y ago
    > but have missed some of the things that MSSQL makes very easy, and by comparison PostgreSQL makes relatively hard. Could you give some examples?
    - tracker1 10y ago
      Namely in the box replication and failover (like checkbox interaction via the GUI) compared to a hard to configure, or expensive to license add-on. IIRC geo indexing was easier in mssql, although much more configurable in pgsql. Not on pg, but linq to entities for .net is really nice, and the pg adapter (iirc) wasn't nearly as good. The node adapters for each are about equal though. Out of the box performance on mssql, and query performance in general was better last time I compared (admittedly about 2 years ago).
deleted 10y ago
[deleted]
kbumsik 10y ago
Not Windows-only anymore. Microsoft is releasing various tools such as SSMS for Linux too.
- severino 10y ago
  No, currently, it is windows only. Maybe, someday, we can say it's not windows-only anymore. But not today.
  - wernercd 10y ago
    Even then... you don't need the DB and SSMS to be on the same box. The installs are on separate ISO's now if I'm not mistaken...
    - mistermann 10y ago
      I believe so yes, it's still not a terribly pleasant experience but WAY better than it was.
  - tracker1 10y ago
    I'm wondering if MS will go the electron route for SSMS, considering how well it's worked out for VS Code.
    - dflenniken 10y ago
      VS Code now has an extension for querying against MSSQL that's cross platform. https://marketplace.visualstudio.com/items?itemName=ms-mssql.mssql https://marketplace.visualstudio.com/items?itemName=ms-mssql... Still missing several things that SSMS has, but it's a nice start!
      - tracker1 10y ago
        Very nice, I was actually meaning it would be a nice to see a full-blown application similarly... just the same, nice to see the extension in VS Code. Consistently impressed with the application, but would like the original multi-doc behavior back over tabs.
douche 10y ago
There are also alternatives to SSMS that run on Linux, like JetBrains DataGrip.
- voltagex_ 10y ago
  DataGrip is great, but it's got a long way to go before it's comparable to SSMS.
  - nimchimpsky 10y ago
    what is it missing ?
    - snuxoll 10y ago
      SQL Agent support is a pretty glaring omission, to be fair they don't support pgAgent either so I regularly end up needing to fire up SSMS or pgAdmin to configure maintenance and summarization jobs.

I doubt any of those 100.000.000.000 commercial products that need MSSQL would run on Linux either. In fact, even SQL Server Management Studio is a Windows-only application.

pmelendez 10y ago

They don't have to. Let's say an enterprise wants to go start moving its backend to the cloud. Now there is a very significant price difference between windows instances and Linux instances. The client commercial product can still run on Windows and the database in Linux

tracker1 10y ago
For that matter, it's been surprisingly easy to get ASP.Net apps to run with mono or .net core in some cases. ymmv of course, and the performance will vary, but it's an option.

dogma1138 10y ago

Actually a lot of them do it's not hard to find some ticketing system or a call center management system that is written in JAVA or PHP and only works with mssql or oracle dbms. The app stack is usually more platform agnostic than you think. Even if it's asp.net you most likely going to be able to run it or easily port it to .net core. Basically having cross platform .net is pointless without having cross platform everything else especially MSSQL.

tracker1 10y ago
I was surprised how easy it was to get a couple asp.net apps running under docker dotnet-onbuild base containers... I think having SQL Server under linux/docker is a really nice option. Just being able to use it with ci/cd environments in linux is a pretty big thing. I've moved more away from the MS environments the past few years now, but have missed some of the things that MSSQL makes very easy, and by comparison PostgreSQL makes relatively hard. Of course you're paying for it. Having the option to run under Linux is really nice though imho.
- insulanian 10y ago
  > but have missed some of the things that MSSQL makes very easy, and by comparison PostgreSQL makes relatively hard. Could you give some examples?
  - tracker1 10y ago
    Namely in the box replication and failover (like checkbox interaction via the GUI) compared to a hard to configure, or expensive to license add-on. IIRC geo indexing was easier in mssql, although much more configurable in pgsql. Not on pg, but linq to entities for .net is really nice, and the pg adapter (iirc) wasn't nearly as good. The node adapters for each are about equal though. Out of the box performance on mssql, and query performance in general was better last time I compared (admittedly about 2 years ago).

deleted 10y ago

[deleted]

kbumsik 10y ago

Not Windows-only anymore. Microsoft is releasing various tools such as SSMS for Linux too.

severino 10y ago
No, currently, it is windows only. Maybe, someday, we can say it's not windows-only anymore. But not today.
- wernercd 10y ago
  Even then... you don't need the DB and SSMS to be on the same box. The installs are on separate ISO's now if I'm not mistaken...
  - mistermann 10y ago
    I believe so yes, it's still not a terribly pleasant experience but WAY better than it was.
- tracker1 10y ago
  I'm wondering if MS will go the electron route for SSMS, considering how well it's worked out for VS Code.
  - dflenniken 10y ago
    VS Code now has an extension for querying against MSSQL that's cross platform. https://marketplace.visualstudio.com/items?itemName=ms-mssql.mssql https://marketplace.visualstudio.com/items?itemName=ms-mssql... Still missing several things that SSMS has, but it's a nice start!
    - tracker1 10y ago
      Very nice, I was actually meaning it would be a nice to see a full-blown application similarly... just the same, nice to see the extension in VS Code. Consistently impressed with the application, but would like the original multi-doc behavior back over tabs.

douche 10y ago

There are also alternatives to SSMS that run on Linux, like JetBrains DataGrip.

voltagex_ 10y ago
DataGrip is great, but it's got a long way to go before it's comparable to SSMS.
- nimchimpsky 10y ago
  what is it missing ?
  - snuxoll 10y ago
    SQL Agent support is a pretty glaring omission, to be fair they don't support pgAgent either so I regularly end up needing to fire up SSMS or pgAdmin to configure maintenance and summarization jobs.