SQL Server 2017 Setup on Redhat Linux Or Migrate SQL Server 2012 DB on Window Server to SQl Server 2017 on Redhat Linux

 

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.

Prerequisite

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

 

copy software on /tmp location and give rights to sqlserver user

execute below command

 

Once setup completed below message will come

 

Then below command for SQL server confguration

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

 

for convenience add bash profile for sqlserver user with below entry

 

while logging to SQLSERVER user you can connect locally with below command

 

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

 

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:

 

Conclusions

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 .

Rajeev Shastri
Author: Rajeev Shastri

Database Administrator With experience on SQL SERVER,Oracle and NOSQL DB

Leave a Reply

Your email address will not be published. Required fields are marked *