Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Microsoft announces the next version SQL Server for Windows and Linux

techcrunch.com

Post reply on HN
Print view View original

41–50 of 92 posts

Re: Microsoft announces the next version SQL Server for Windows and Linux

#41

Post by vkjv »

wila wrote: post #33

This is great news and I am looking forward to be able to use MSSQL from within linux and macOS. Hopefully the client support is going to be cross platform too. The one thing in the article that puzzled me is: Thanks to its support for Docker containers, even macOS users will be able to run it. Indeed, Microsoft is betting on containers as one of the main distribution mechanisms for the preview Wasn't there a golden…

> Wasn't there a golden rule to not store persistent data in a container?

You shouldn't store persistent data in the container. However, you can mount external storage and read/write to it from inside the container. The most simple example of this is mapping a path from the host.

EDIT:

In fact, the MS documentation gives an example of exactly this. https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-...

> sudo docker run –e 'ACCEPT_EULA=Y' –e 'SA_PASSWORD=' -p 1433:1433 -v :/var/opt/mssql -d microsoft/mssql-server-linux

Re: Microsoft announces the next version SQL Server for Windows and Linux

#42

Post by edpichler »

emcrazyone wrote: post #32

I've not looked at MS-SQL in a long time. My business ships software using PostgreSQL. Does anyone have, in their opinion, compelling reasons why one should consider MS-SQL on Linux for either a new project or potential migrating too? Consider too, PostgreSQL runs under Windows as a service too. What does MS-SQL have that PostgreSQL does not?

I think this product in targeted to companies who already have a MS-SQL database, and now can consider use Linux.

Re: Microsoft announces the next version SQL Server for Windows and Linux

#43

Post by teilo »

wila wrote: post #33

This is great news and I am looking forward to be able to use MSSQL from within linux and macOS. Hopefully the client support is going to be cross platform too. The one thing in the article that puzzled me is: Thanks to its support for Docker containers, even macOS users will be able to run it. Indeed, Microsoft is betting on containers as one of the main distribution mechanisms for the preview Wasn't there a golden…

It does not persist data. It requires shared volume support for that, and they are not currently supporting shared volumes on macOS, which makes this, for all practical purposes, useless on a Mac.

I have it running in Vagrant, in the meantime. Easiest SQL Server install I have ever done.

Re: Microsoft announces the next version SQL Server for Windows and Linux

#45

Post by teilo »

cygned wrote: post #4

Microsoft has created an apt repository for Ubuntu. That's really nice. https://docs.microsoft.com/en-gb/sql/linux/sql-server-linux-...

I have this running on Debian 8. Only needs openssl from jessie-backports, and it works flawlessly.

Re: Microsoft announces the next version SQL Server for Windows and Linux

#47

Post by wavefunction »

edpichler wrote: post #42
emcrazyone wrote: post #32

I've not looked at MS-SQL in a long time. My business ships software using PostgreSQL. Does anyone have, in their opinion, compelling reasons why one should consider MS-SQL on Linux for either a new project or potential migrating too? Consider too, PostgreSQL runs under Windows as a service too. What does MS-SQL have that PostgreSQL does not?

I think this product in targeted to companies who already have a MS-SQL database, and now can consider use Linux.

^^^Or even move their on-premise or NOC'd IIS servers into Azure's Linux environment.
Post reply on HN