MSSQL on Linux – the details • Hacker News Board

MSSQL on Linux – the details

#1

Post by winged » Wed, Dec 28, 2016, 9:45 AM UTC

MSSQL on Linux – the details
adfinis-sygroup.ch

Re: MSSQL on Linux – the details

#2

Post by bdcravens » Wed, Dec 28, 2016, 10:53 AM UTC

Article implies only clients for managing SQL Server are SSMS or VS Code - for most of what you'd need to do, tools like DataGrip, Navicat, or any other solution that supports JDBC works well on most platforms.

Re: MSSQL on Linux – the details

#3

Post by koltaggar » Wed, Dec 28, 2016, 11:13 AM UTC

Do people actually run this ?

Re: MSSQL on Linux – the details

#4

Post by ishtu » Wed, Dec 28, 2016, 11:17 AM UTC

user space version of the NT kernel (known as NTUM - "user mode NT")

This is pretty neat. Wonder if people could use it to run other Windows stuff on Linux

Edit: formatting

Re: MSSQL on Linux – the details

#5

Post by womitt » Wed, Dec 28, 2016, 11:19 AM UTC

Any valid use cases?

No offence, was just wondering why would anybody use it...

Re: MSSQL on Linux – the details

#6

Post by thinkMOAR » Wed, Dec 28, 2016, 11:25 AM UTC

"It's astonishing but true - Microsoft really has figured out how to package software for Linux. \o/"

It is not very difficult to create linux packages, writing microsoft has figured it out makes it sound as if its rocket science. It also sounds as if these packages are for 'linux' but the ones mentioned in the article are specifically for CentOS linux.

And as far as i understand they only released packages for CentOS/REHL and Ubuntu. Not all linux distributions.

Re: MSSQL on Linux – the details

#7

Post by mootothemax » Wed, Dec 28, 2016, 11:26 AM UTC

womitt wrote: post #5

Any valid use cases? No offence, was just wondering why would anybody use it...

> Any valid use cases?

I'm personally a fully competent Linux sysadmin, and an extremely incompetent Windows sysadmin.

SQL Server is great, I love .NET, and the only thing holding me back all these years has been the Windows system requirement.

Re: MSSQL on Linux – the details

#8

Post by littlehood » Wed, Dec 28, 2016, 11:29 AM UTC

womitt wrote: post #5

Any valid use cases? No offence, was just wondering why would anybody use it...

Porting existing/legacy software to cloud. Though SQL Server is just a part of the stack and you still can't fool software it's running Windows.

But it's like SQL Server on Windows Server Nano - nobody asks for it, because only full system has required tools and features.

Re: MSSQL on Linux – the details

#9

Post by teh_klev » Wed, Dec 28, 2016, 11:45 AM UTC

bdcravens wrote: post #2

Article implies only clients for managing SQL Server are SSMS or VS Code - for most of what you'd need to do, tools like DataGrip, Navicat, or any other solution that supports JDBC works well on most platforms.

Not forgetting HeidiSQL which although is a Windows app runs well under Wine:

http://www.heidisql.com/download.php

https://appdb.winehq.org/appview.php?iAppId=3326

Re: MSSQL on Linux – the details

#10

Post by gaius » Wed, Dec 28, 2016, 11:53 AM UTC

womitt wrote: post #5

Any valid use cases? No offence, was just wondering why would anybody use it...

Because SQL Server is actually an excellent database, fast, reliable and full-featured. Consider that Postgres only got parallel queries a few months ago that SQL Server has had for 15 years! And in terms of replication, clustering etc SQL Server is still well ahead of PG. Now don't get me wrong I am a huge PG fan, but burying your head in the sand "because it's Microsoft" is unprofessional.