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?
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 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.
SQL Server Express is available to use in Production. It's just restricted by the DB size (10GB) and doesn't come with some other features, like SQL Agent, High availability, transparent data encryption, etc...