How do I install Microsoft SQL Server for linux (fedora)?

7
votes

How can I install Microsoft SQL Server for linux (fedora) ? I read about Microsoft® SQL Server® ODBC Driver 1.0 for Linux but haven't understood what is it. I wanted to connect to sql server for the java application operating on linux.

4
javasql-serverlinuxfedora
Not to be flippant, but why wouldn't you use PostgreSQL/*nix instead? – OMG Ponies
There is a native JDBC driver for MS SQL, using the ODBC one with Java is a needless pain in the butt. – trognanders

4 Answers

17
votes

Microsoft® SQL Server® ODBC Driver 1.0 for Linux is a linux driver for native connectivity to an MSSQL Server database.

MSSQL will only run on Windows. MSSQL 2017 onward you can install on linux server.

8
votes

you can install MSSQL on Linux and on Windows. Solution would be to install Windows as a virtual machine and use the ODBC driver(helps you connect to MSSQL programmatically) which you found and use in linux .

https://social.technet.microsoft.com/wiki/contents/articles/52294.sql-server-installation-on-ubuntu.aspx

2
votes

Nowadays you can install SQL Server on linux, but for now, only for Red Hat and Ubuntu and is still on Beta.

The following links tell you

How to install SQL Server in Ubuntu and Red Hat

Install SQL Server on Red Hat

Install SQL Server on Ubuntu

0
votes

You can install mssql on Fedora. Refer to the following link: https://youtu.be/EZw_fWLr93Y