LocalDB OverviewUNIXBusinessApplication

LocalDB is the #10 ranked solution in top Relational Databases. PeerSpot users give LocalDB an average rating of 10.0 out of 10. LocalDB is most commonly compared to SQL Server: LocalDB vs SQL Server. LocalDB is popular among the large enterprise segment, accounting for 62% of users researching this solution on PeerSpot. The top industry researching this solution are professionals from a comms service provider, accounting for 20% of all views.
Buyer's Guide

Download the Relational Databases Tools Buyer's Guide including reviews and more. Updated: November 2022

What is LocalDB?
LocalDB is a lightweight version of the SQL Server Express Database Engine that is targeted for program development. LocalDB starts on demand and runs in user mode, so there is no complex configuration.
LocalDB Customers
AstraZeneca, Kienzle Automotive GmbH, Kodak Alaris, Unilever, Floatel International and Kongsberg Maritime, MyHero
LocalDB Video

Archived LocalDB Reviews (more than two years old)

Filter by:
Filter Reviews
Industry
Loading...
Filter Unavailable
Company Size
Loading...
Filter Unavailable
Job Level
Loading...
Filter Unavailable
Rating
Loading...
Filter Unavailable
Considered
Loading...
Filter Unavailable
Order by:
Loading...
  • Date
  • Highest Rating
  • Lowest Rating
  • Review Length
Search:
Showingreviews based on the current filters. Reset all filters
Co-Founder and Chief Executive Officer at EXEC
Real User
Good for the development process, generally stable, and easy to set up
Pros and Cons
  • "The initial setup was simple."
  • "The solution needs to create a management tool. Right now, the solution has tools for creating a local installation, but it's too simplistic. We need something that's a bit more complex so that we can extend the tools with our scripts."

What is our primary use case?

We primarily use the solution during the development process. When our developers need to connect to the database during an application's creation, they install LocalDB on their development workstation and use it to connect.

How has it helped my organization?

This tool help us build apps quicker and faster.

What is most valuable?

Database Engine which is compatible with on-premise and cloud release.

What needs improvement?

The solution needs to create a management tool. Right now, the solution has tools for creating a local installation, but it's too simplistic. We need something that's a bit more complex so that we can extend the tools with our scripts.

Technical support could be quicker to respond to tickets.

Buyer's Guide
Relational Databases Tools
November 2022
Find out what your peers are saying about Microsoft, Oracle, MariaDB and others in Relational Databases Tools. Updated: November 2022.
656,474 professionals have used our research since 2012.

For how long have I used the solution?

I've been using the solution for three years. 

What do I think about the stability of the solution?

The solution is stable. Occasionally. we play with newer versions when they are available for us. In these cases, sometimes it's not stable. However, when we use the production version of DB, it is very stable.

What do I think about the scalability of the solution?

Currently, we have a team of 25 using the solution.

How are customer service and support?

Technical support is good. We don't have any problem with technical support from Microsoft, especially when we're talking about support for Azure services. It's very quick. When we are talking about on-premise solutions, however, sometimes we must wait for a few days for issues to be resolved.

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

We sometimes use different products, including PostgreSQL , among others, especially during the deployment process.

How was the initial setup?

The initial setup was simple.

What about the implementation team?

Our team handled the implementation.

Which other solutions did I evaluate?

Azure SQL

What other advice do I have?

We've used the solution about 100 times across a number of different projects. We're currently using the 2014 and 2017 versions of the solution with an on-premises deployment model. 

We're partners with Microsoft.

I'd recommend the solution for those looking for something to assist with their development process.

I'd rate the solution nine out of ten.

Which deployment model are you using for this solution?

On-premises
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner.
PeerSpot user
IT Architect and Test Tool Designer at a comms service provider with 5,001-10,000 employees
Real User
A database with excellent reporting features, good technical support, and a straightforward setup
Pros and Cons
  • "The initial setup is very straightforward. The guidelines are very easy to follow. Maintenance is very easy and requires very little manpower."
  • "The ALM features can be improved, but the database by itself is reliable."

What is our primary use case?

We primarily use the solution for our database.

What is most valuable?

The solution has powerful reporting features that are very valuable. The user interface is the standard SQL management tool, so it's very easy to navigate.

What needs improvement?

The ALM features can be improved, but the database by itself is reliable.

For how long have I used the solution?

I've been using the solution for three years.

What do I think about the stability of the solution?

The solution is very stable. We haven't had any issues in this regard.

How are customer service and technical support?

So far, we've been very satisfied with technical support.

How was the initial setup?

The initial setup is very straightforward. The guidelines are very easy to follow. Maintenance is very easy and requires very little manpower.

What about the implementation team?

We had a local partner assist us with the implementation. They were extremely knowledgeable. 

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

The solution isn't expensive. My company has a subscription model for software licenses. This way, it's very inexpensive because if you have one big cluster of databases, you have literally no cost.

What other advice do I have?

We use the on-premises deployment model.

I would rate the solution nine out of ten.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Buyer's Guide
Relational Databases Tools
November 2022
Find out what your peers are saying about Microsoft, Oracle, MariaDB and others in Relational Databases Tools. Updated: November 2022.
656,474 professionals have used our research since 2012.
PeerSpot user
Senior business Intelligence consultant at Asociación SevillaUP
Consultant
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.
PeerSpot user
it_user70134 - PeerSpot reviewer
it_user70134Senior business Intelligence consultant at Asociación SevillaUP
Consultant

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

See all 2 comments