3 ms·
It's not a trivial thing - docker and sandstorm.io might be two examples of making some decent headway here. Just today I set up a postgres and ms sql server f
by e12e 6y ago
It's not a trivial thing - docker and sandstorm.io might be two examples of making some decent headway here.
Just today I set up a postgres and ms sql server for testing - pretty much identically, running out of their own named docker containers (for those not aware, it's even more similar than it sounds, ms sql runs on Linux now).
- effie 6y agoWhy do you want to run MS SQL on Linux? What will you do when the db gets locked or crashes? You call Microsoft and wait?
- e12e 6y ago> What will you do when the db gets locked or crashes? You call Microsoft and wait? Actually, it would appear ms is quite serious about sql server on Linux: https://docs.microsoft.com/en-us/troubleshoot/sql/linux/choosing-licensing-model-using-mssql-conf https://docs.microsoft.com/en-us/troubleshoot/sql/linux/choo... So I guess, similar to running sql server on windows?
- e12e 6y agoFor development - I was waiting for a dba to sort access to the new prod server, and needed to check that the current app build was minimally working correctly talking to an ms sql instance. It might be interesting to run in CI as well. Running any rdbms in production in docker isn't a great idea. But for dev and test it can be great. For my use case, we deploy mostly to traditional setup (dedicated sql server) - but I could also see it useful for prototyping deployment to mssql in azure cloud.