Installing MS SQL Server 2017 Express on CentOS 7.4
-
Having just released yesterday, it is time to get Microsoft's SQL Server 2017 installed on CentOS 7.4. I have a CentOS 7.4 VM fully updated and ready to go on my Scale .
First we add the MS SQL Server RHEL repository to our system.
curl -o /etc/yum.repos.d/mssql-server.repo https://packages.microsoft.com/config/rhel/7/mssql-server.repoThen we just do our normal YUM based installation commands.
yum install -y mssql-serverWe then configure using the build in command line configuration utility:
/opt/mssql/bin/mssql-conf setupOnce installed, MS SQL Server is managed via the standard systemctl commands.
And that is all folks. After that it is up and running. Worth noting, you will need 4GB of RAM to even fire up the process, which is a tad excessive when you consider that you can run its competition in production with far less RAM than that. And only XFS and EXT4 filesystems are supported. That means no ZFS, no BtrFS, no JFS2, etc.
-
Have you tried connecting with SQL Server Management Studio?
-
@black3dynamite said in Installing MS SQL Server 2017 Express on CentOS 7.4:
Have you tried connecting with SQL Server Management Studio?
Not yet, but I hope to get time to do so.
-
@scottalanmiller said in Installing MS SQL Server 2017 Express on CentOS 7.4:
MS SQL
It should be marketed as:
For folks that got locked in with MS SQL, now at-least you can enjoy the benefits of Linux.
-
@emad-r said in Installing MS SQL Server 2017 Express on CentOS 7.4:
@scottalanmiller said in Installing MS SQL Server 2017 Express on CentOS 7.4:
MS SQL
It should be marketed as:
For folks that got locked in with MS SQL, now at-least you can enjoy the benefits of Linux.
It makes it possible to actually use Express for free!
-
I had no idea that this was a thing! Interesting.
-
@wrx7m said in Installing MS SQL Server 2017 Express on CentOS 7.4:
I had no idea that this was a thing! Interesting.
Oh yeah, biggest news in Microsoft databases in years. They've been touting it for over a year now. Huge news. Really changes their database game, assuming that it works well. Way easier to install on Linux than on Windows, which is awesome.
-
@scottalanmiller said in Installing MS SQL Server 2017 Express on CentOS 7.4:
@wrx7m said in Installing MS SQL Server 2017 Express on CentOS 7.4:
I had no idea that this was a thing! Interesting.
Oh yeah, biggest news in Microsoft databases in years. They've been touting it for over a year now. Huge news. Really changes their database game, assuming that it works well. Way easier to install on Linux than on Windows, which is awesome.
Wow. Easier is almost always better.
-
@scottalanmiller said in Installing MS SQL Server 2017 Express on CentOS 7.4:
Way easier to install on Linux than on Windows, which is awesome.
It's a bear to install on Windows. I'm amazed Microsoft isn't investing in a package manager-esque system or at least getting their devs to work on Chocolately.
-
@coliver said in Installing MS SQL Server 2017 Express on CentOS 7.4:
@scottalanmiller said in Installing MS SQL Server 2017 Express on CentOS 7.4:
Way easier to install on Linux than on Windows, which is awesome.
It's a bear to install on Windows. I'm amazed Microsoft isn't investing in a package manager-esque system or at least getting their devs to work on Chocolately.
Even MS doesn't prioritize Windows.
-
@wrx7m said in Installing MS SQL Server 2017 Express on CentOS 7.4:
@scottalanmiller said in Installing MS SQL Server 2017 Express on CentOS 7.4:
@wrx7m said in Installing MS SQL Server 2017 Express on CentOS 7.4:
I had no idea that this was a thing! Interesting.
Oh yeah, biggest news in Microsoft databases in years. They've been touting it for over a year now. Huge news. Really changes their database game, assuming that it works well. Way easier to install on Linux than on Windows, which is awesome.
Wow. Easier is almost always better.
Yup, well the database world has always been a UNIX one. Sybase, that MS SQL Server is forked from, is a UNIX product, too. Has always run better there. And now that Windows doesn't "go big" any longer, moving SQL Server to Linux is its only path to giant RISC enterprise scale database servers that they need for giant relational database systems. Once Windows dropped IA64 support, they were screwed for MS SQL Server being taken seriously by large shops. Now they can play in that space again.
-
So, my personal feeling, is that the Linux port of SQL Server will be the main one in no time. MS needs it to be every bit on par or better than the Windows version.
-
@scottalanmiller said in Installing MS SQL Server 2017 Express on CentOS 7.4:
So, my personal feeling, is that the Linux port of SQL Server will be the main one in no time. MS needs it to be every bit on par or better than the Windows version.
Shouldn't be too difficult. I'll be interested to see if SQL Manager works with this version.
-
@coliver said in Installing MS SQL Server 2017 Express on CentOS 7.4:
@scottalanmiller said in Installing MS SQL Server 2017 Express on CentOS 7.4:
So, my personal feeling, is that the Linux port of SQL Server will be the main one in no time. MS needs it to be every bit on par or better than the Windows version.
Shouldn't be too difficult. I'll be interested to see if SQL Manager works with this version.
It does, and is available on Linux, too. It has to or nothing work work as it works through the singular connection. This isn't a different "version" of SQL Server, it is just deployed to Linux. It's full SQL Server and works with all tools.
-
@scottalanmiller said in Installing MS SQL Server 2017 Express on CentOS 7.4:
@coliver said in Installing MS SQL Server 2017 Express on CentOS 7.4:
@scottalanmiller said in Installing MS SQL Server 2017 Express on CentOS 7.4:
So, my personal feeling, is that the Linux port of SQL Server will be the main one in no time. MS needs it to be every bit on par or better than the Windows version.
Shouldn't be too difficult. I'll be interested to see if SQL Manager works with this version.
It does, and is available on Linux, too. It has to or nothing work work as it works through the singular connection. This isn't a different "version" of SQL Server, it is just deployed to Linux. It's full SQL Server and works with all tools.
Good to know.
-
I was waiting for this release. I know a few developers who can’t wait to try this. Looks like I need to spin this up.
-
@fuznutz04 said in Installing MS SQL Server 2017 Express on CentOS 7.4:
I was waiting for this release. I know a few developers who can’t wait to try this. Looks like I need to spin this up.
I have been eagerly anticipating it myself as we have some MS SQL based stuff that I can potentially move now
-
This is cool, don't think management here would go for it. Too much of a M$ fanboy lol
-
@hobbit666 said in Installing MS SQL Server 2017 Express on CentOS 7.4:
This is cool, don't think management here would go for it. Too much of a M$ fanboy lol
Just tell them that this is MS' big play for SQL Server. True fanbois would just on it
-
@scottalanmiller said in Installing MS SQL Server 2017 Express on CentOS 7.4:
After that it is up and running. Worth noting, you will need 4GB of RAM to even fire up the process, which is a tad excessive when you consider that you can run its competition in production with far less RAM than that.
Current docs show only 2GB required. I built the VM with 3GB and 2 vCPU.
@scottalanmiller said in Installing MS SQL Server 2017 Express on CentOS 7.4:
And only XFS and EXT4 filesystems are supported. That means no ZFS, no BtrFS, no JFS2, etc.
Who cares?
