Since LocalDB is for development purpose, then use what DB for production?

Question

I'm getting a little confused here between LocalDB and SQL Server Express. I have read from websites that LocalDB is an improved version of SQL Server Express (source). I would assume this implies that LocalDB is replacing SQL Server Express.

The confusing thing, however, is that it was also mentioned on several websites that LocalDB is only for development purposes, and it's not meant for production use.

In this case, I will do my development and testing of my web application with LocalDB on my computer. Since LocalDB is a replacement for SQL Server Express and also not for production use, then what database (other than the full SQL Server if I don't have the money) should I use when I'm ready to publish my application?

Answer 1

I would assume this implies that LocalDB is replacing SQL Server Express.

Your assumption is incorrect. Keep reading the article you linked...

LocalDB is not a replacement for SQL Server Express -- it is an addition to SQL Server Express lineup. While LocalDB is meant for developers, the regular SQL Server Express will continue to exist as a free SQL Server edition, fully compatible with and easily upgradeable to higher SQL Server editions.

You would still use SQL Server Express or a higher version of SQL Server for production use. Or better yet, abstract your application from the database in such a way that you could use any server (MySQL, Oracle, etc.)