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
