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.
-
@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?
-
@JaredBusch 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:
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?
A lot of people, especially on places like FreeNAS forums or
tend to be very "anti" traditional solid filesystems and are religiously addicted to ZFS and BtrFS or ReFS style filesystems. -
@scottalanmiller said in Installing MS SQL Server 2017 Express on CentOS 7.4:
@JaredBusch 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:
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?
A lot of people, especially on places like FreeNAS forums or
tend to be very "anti" traditional solid filesystems and are religiously addicted to ZFS and BtrFS or ReFS style filesystems.I don't care about stupid. Everything RHEL/Fedora defaults to XFS.
No idea what Debian 9 or Ubuntu default to.
-
@JaredBusch 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:
@JaredBusch 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:
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?
A lot of people, especially on places like FreeNAS forums or
tend to be very "anti" traditional solid filesystems and are religiously addicted to ZFS and BtrFS or ReFS style filesystems.I don't care about stupid. Everything RHEL/Fedora defaults to XFS.
No idea what Debian 9 or Ubuntu default to.
EXT4
-
Just installed on CentOS 7.6 with XFS. Still flawless install.
