[slackfan]

I actually have been running SQL Server for linux for the past few months.

In a docker container, no less.

This is entirely for testing a part of our application that needs to connect to legacy mssql servers. The server is spun up, databases are created programmatically, tests are run, and then the container is destroyed.

As for running this in production, ahahaha no.

[coding123]

I was in this thread looking for this reply. If nothing else, the ability to run code on your Mac laptop running MSSQL server in docker is a huge win, even for what may later be a Windows deployment of MSSQL server. I definitely see the use-case for automating QA workloads and running tests against a real MSSQL server on what is otherwise a fully Linux based build system. The cheapest way to run MSSQL server (TCO which includes the human cost) is still likely Windows, but the docker-izing of MSSQL opens up soo many doors now.

That all being said, I would expect that there are also companies moving to use MSSQL in Linux for production as well, but personally, I would wait a couple of years to hear other's experiences.

[slackfan]

Yeah, it's pretty great. We evaluated spinning up RDS MSsql instances for our testing, and found the time that it took to spin up one of those to be extremely prohibitive for use with CI pipelines, I mean something to the tune of 20 minutes for the instance to come up. Whereas with docker and mssql-linux, we only have to (at most) have a 10-15 second delay before the container is fully online. Definitely great for devs to run their local tests against, and great for me to be able to do some minor admining via the CLI tools provided in the container.

[james_anderson]

I've been doing similar stuff with docker in my CI pipelines. So are you testing your app on Linux SQL Servers and then deploying to Windows SQL Servers? Should be OK...

[slackfan]

Data is data, and a stored proc should behave the same across OSes. Otherwise Microsoft is doing a shitty job developing mssql. Here's a hint, they aren't.

[flachsechs]

so is your apprehension because of sql server on linux, or because of docker, or because of the combination of the two? this post is snarky but lacks real information.

[slackfan]

Because if we were to migrate off legacy systems we'd go with postgres.

[lochii]

I'd love to see your dockerfile, would you consider sharing it?

[slackfan]

We just roll the default

https://hub.docker.com/r/microsoft/mssql-server-linux/

So no real dockerfile