Menu
Is using SQL Express in a production environment a reasonable choice?
I looked at Microsoft's comparison chart:
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
I would be using SQL Express with a small to mid-sized web site. I don't believe I would exceed the 4GB database size limit. Is SQL Express typically supported in shared hosting environments? Is there something I'm missing that would make SQL Express an unreasonable choice?
478
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.
Answers. Yes, it is.
Express edition limitations Microsoft SQL Server Express has a 10 GB maximum database size and other important limits. High load scenarios are not supported by Express. Symptoms can include database connection errors. Express has a "LocalDB" preset.
What is the SQL Server Developer Edition? It is an edition for Developers. It is free, but you cannot use it in production. It contains all the SQL Server Enterprise functionality, but it cannot be deployed in production.
I know many people using SQL Express for production and it works well, the biggest limiting factor is the absence of SQL Agent for automated backups. To automate backups you have to either take a VM image (if on a VPS) or use windows scheduler or some other technology.
The only other major limiting factor is the ram limitation, but for a small site I have not really noticed that being too much of an actual issue.
92
Many cheap hosting companies uses SQL Express. And I know from personal experience that SQL Express is a viable solution for most things.
"Most things" includes a large project in a production environment.
20
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
