LocalDB Review

I evaluated Oracle & PostgreSQL but am sticking with SQL Server because of its vast knowledge base & better feature list.


What is most valuable?

The memory footprint is the smallest in its category of products. I think Microsoft did a very good job squeezing as many features as possible in such a tiny executable. The price, being it free, it's of course a plus. And the capability to do almost everything as in the commercial version. When using a developer machine or also a virtual machine, it is essential that every MB of memory is well utilized. The binaries are loaded in memory only when needed. It uses the same client libraries as its bigger siblings, including the Native client. Unlike the Compact version which uses a limited set of functionality this LocalDB has Stored Procedures, Geometry, Geography data types, online backup, transactions, data integrity etc. It runs as a separate process as opposed to in-proc DLL.

How has it helped my organization?

For the development process and for small Business Intelligence projects, this software gives a very good head start because the installation is merely seconds. It runs in the current user context, and this allows the developer to be freed from switching accounts many times during the develop/deploy/test phase.

What needs improvement?

The storage limit is about 10GB, so for medium to big databases it is not applicable.

For how long have I used the solution?

I've been using SQL Server since version 7, so approximately 15 years, this 2012 Express is the latest release of this software. This is a free lightweight version of the 2012 full fledged product.

What was my experience with deployment of the solution?

No. The setup is really Next -> Accept ->Next -> Finish.

What do I think about the stability of the solution?

No.

What do I think about the scalability of the solution?

Of course you won't use LocalDB if you need to scale. I mean, in order to scale one should buy the commercial version of SQL Server. But even so, the database will not need any modification. According to Microsoft web site: "Upgrade from SQL Express to paid SQL Server editions is a matter of typing in a license key and no installation is required"

How are customer service and technical support?

Customer Service:

I did not use the customer service, the sheer amount of information, articles, blogs and forums about SQL Server covers practically the 99% of issues one may encounter with this database system

Technical Support:

I'd rate it "good enough", based on previous products experiences.

Which solution did I use previously and why did I switch?

I used both SQL Server and other open source RDBMS. I switched because of the vast knowledge base and the far better feature list in SQL Server.

How was the initial setup?

Very straightforward. One download, pick the 32 or 64 bit version and run the SqlLocalDB.msi installer

What about the implementation team?

In house, literally in "my" house.

What's my experience with pricing, setup cost, and licensing?

Setup cost, 0€. Day to day cost 0€, excluding power consumption.

Which other solutions did I evaluate?

I also used Oracle 11 XE, MySQL, PostgreSQL.

What other advice do I have?

The only caveat is to pay attention to the user context. The SQL engine doesn't run with a privileged or system account, so it really has only the permissions of the currently logged in user (files, network, etc.). It is advisable to install the SQL Server management studio (also free) to administer and configure it

Disclosure: I am a real user, and this review is based on my own experience and opinions.
2 Comments
author avatarGaryM
TOP 5POPULARReal User

This review is great but should just make clear, this is express version only. There are many versions of sql server.

author avatarSenior business Intelligence consultant at Asociación SevillaUP
TOP 20Consultant

Yes, you're correct. In fact it is the localDB version, not express. I should have specified it in the title. Thanks
Davide

Guest