SQL Server 2017 is supported on Red Hat Enterprise Linux (RHEL), SUSE Linux Enterprise Server (SLES), and Ubuntu. It is also supported as a Docker image, which can run on Docker Engine on Linux or Docker for Windows/Mac.
Even Sql Server 2017 can be deployed and managed by Redhat openshift and kubernetes.
Minimal Requirement for SQL server 2017 on REDHAT Enterprise Linux 7.3. is 2GB Ram with disk space 6GB ,2 core,XFS file system and X64- compatible.
Download Redhat enterprise distribution from website of REDHAT
Installation can be done on Physical or VM machine with initial requirement with DVD
set Language English and in software Selection Put installation With GUI.
Set Sqlserver in usercreation and same can be used for SQLsetup.
Download SQL Server 2017 repository from LINUX machine if internet available or Download
from REDHAT Satellite server then copy tp server or compress format also can be downloaded from windows Machine
Command from Linux machine
sudo curl -o /etc/yum.repos.d/mssql-server.repo htpps://packages.microsoft.com/config/rhel/7/mssql-server-2017.repo
copy software on /tmp location and give rights to sqlserver user
execute below command
sudo yum install -y mssql-server
Once setup completed below message will come
Then below command for SQL server confguration
sudo /opt/mssql/bin/mssql-conf setup
provide strong password for SA account and version you want to use
Give Strong SA password
Now you SQL server on Redhat Enterprise Linux installed and accessibility for SQL Server from outside world can be set on linux box or even port number also can be changed.
Configure Firewall rule and check SQL server is running
sudo firewall-cmd --zone=public --add-port=1433/tcp –permanent
sudo firewall-cmd –reload
systemctl status mssql-server
sudo systemctl restart mssql-server
for convenience add bash profile for sqlserver user with below entry
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bash_profile echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc source ~/.bashrc
while logging to SQLSERVER user you can connect locally with below command
sqlcmd -S hostname(Linux Machine) -U SA -P 'password'
if you need SQL server agent and command line tool,SQL operation studio on Linux Server then separate Linux RPM need to downloaded and install on Linux machine
sudo yum install mssql-server-agent
sudo yum install unixODBC-utf16 unixODBC-utf16-devel
yum install libXScrnSaver
sudo yum install sqlops-linux-0.26.6.rpm
SQL server running on Linux can be connected with SQL server Management studio installed on window Machine and all database operation can be performed. SQL server database running on SQL server 2012 on windows server can be migrated to SQL server 2017 running on Redhat linux by copying db backup file to default directory of Database in Linux machine and restore with SQL server Management studio running on windows machine or by T-SQL. Backup yourdb from windows SQL server and copy backup file from windows machine to Linux box by winscp.
Connect SQL server from linux machine:
sqlcmd -S localhost -U SA RESTORE DATABASE YourDB FROM DISK = '/var/opt/mssql/backup/YourDB.bak' WITH MOVE 'YourDB' TO '/var/opt/mssql/data/YourDB.mdf', MOVE 'YourDB_Log' TO '/var/opt/mssql/data/YourDB_Log.ldf'
The availability of Microsoft SQL Server on Linux provides a useful new option for database administrators. SQL 2017 can potentially save on Windows license costs and even simplify server administration for primarily Linux based environments that would only use Windows servers as MS SQL .