Safe money on MSSQL Licensing (Run it More Stable)

YOu can Run MSSQL on Linux?

Thank you Microsoft I can stick with Linux for Longer;-)

And Cheaper.....

So Image likes are at https://hub.docker.com/_/microsoft-mssql-server

For MSSQL 2019 use:

Get the IMAGE

docker pull mcr.microsoft.com/mssql/server:2019-latest

Start the IMAGE

sudo docker run -e "ACCEPT_EULA=Y" -e "SA_PASSWORD=YOurPassword" -p 1433:1433 --name sql1 -d mcr.microsoft.com/mssql/server:2019-latest

Install MSSQL Tools

sudo yum install -y mssql-tools unixODBC-devel

For convenience, add /opt/mssql-tools/bin/ to your PATH environment variable

echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bash_profile
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc
source ~/.bashrc

THat is it....

Connect with

sqlcmd -S localhost -U SA -P '<YourPassword>' or the Docker way

docker exec -it name/id /opt/mssql-tools/bin/sqlcmd -S localhost -U SA -P YourPassword


PS.. Remember to open the Firewall If you going to connect remotely