Geek Answers Handbook

SQL Server Express vs express localdb

I have quite a few problems understanding the differences between regular SQL Server Express and a Localdb expression.

Before you move on to the previous post about this question, I looked at the history of the question several times.

Resources that I found somewhat useful were: Is there a difference between SQL Server Express (2012) and LocalDB? and the official Microsoft page article about it.

I believe that I understand that Express Localdb is a version of SQL Server Express designed for developers to reduce the time it takes to consume the entire “configuration”.

What is the exact configuration? What is the difference If I use Username \ SQLEXPRESS versus (Localdb) \ MSSQLLocalDB, it still creates the database. What are the differences in the timing of publishing your application in production?

+7
visual-studio sql-server-express localdb sql-server-2016-express
source share
1 answer

LocalDB is a special, ineffective version of the SQL Server engine that is not installed as a Windows service, but starts (runs to run) at the request of the ADO.NET client, opening a connection with it. It is intended for single-user scenarios, and not for the use of any products - for production you must use SQL Server Express (or higher)

I have a blog post comparing various engines here: http://erikej.blogspot.dk/2011/01/comparison-of-sql-server-compact-4-and.html

+9
source share

More articles:


All Articles