I'm trying to publish my ASP.NET Core app to Linux for production. My question is, is Microsoft SQL Server Express available for production in Linux? Or do I have to use the paid version?
SQL Server Express, Microsoft's free database edition, can be utilized in the Azure Cloud by installing on an Azure Virtual Machine (VM) – for developing small server-driven applications. It can also be utilized for any production database that is sized at or below the current SQL.
Installing SQL Server Express in LinuxWhile configuring the Server, choose ” 3 “ to install SQL Express Server as shown below and set up an administrator password. At this point your installation is successful.
As a result, MS SQL Server is supported on Red Hat Enterprise Linux, SUSE Enterprise Linux, and Ubuntu, along with Docker containers (and Red Hat OpenShift), AWS, Kubernetes, and as a specialized virtual machine on Azure. Microsoft SQL Server is not the only SQL database available for Linux systems.
Starting with SQL Server 2017 (14. x), SQL Server runs on Linux. It's the same SQL Server database engine, with many similar features and services regardless of your operating system. SQL Server 2019 is available!
SQL Server Express can be used in production (beware of the limitations, like the 10GB cap), but according to this link Express is available for Linux.
As discussed in Install Microsoft SQL Server 2017 on Fedora 29/CentOS 7, just install the mssql-server
package and choose "3) Express (free)" in the configuration step.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With