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 rule to not store persistent data in a container? I can see it being useful for testing, but am wondering if this is going to be suggested for deployment as well.
Of course one can locate the database on external block storage, but that makes it less easy to support due to having multiple parts. (not that that is a very big issue)
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.
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.
Comments
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:
Wasn't there a golden rule to not store persistent data in a container? I can see it being useful for testing, but am wondering if this is going to be suggested for deployment as well.Of course one can locate the database on external block storage, but that makes it less easy to support due to having multiple parts. (not that that is a very big issue)
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-...
interesting, thanks!
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.
I would assume that the Mac version is not intended to be a production server, but a convenience for developers.
I would also not assume MS will be supporting Mac servers in production because of the small market share for things like RDBMS hosts.