LocalDB deployment on client PC

sql-server installation sql-server-express sql-server-2012 localdb
Steve picture Steve · Mar 11, 2012 · Viewed 45.8k times · Source

I am very intrigued by this new version of SQL Server Express.

It's not clear (to me) what a setup program should do to deploy an application that use a LocalDB.

Is it required to install SQL Server Express on the client PC and then attach the MDF file?

Or it's only required to run the LocalDB.msi and it works as a standalone file like SQL Server Compact?

Answer

Krzysztof Kozielczyk picture Krzysztof Kozielczyk · Mar 13, 2012

You don't need to install SQL Server Express to use LocalDB, as LocalDB is SQL Server Express, just easier to install.

Once LocalDB is installed you can use AttachDbFileName property of the connection string to "open" an MDF file. Keep in mind that the same file can only be opened by a single LocalDB instance (single Windows login) at any given time, so this is not a data-sharing feature.

Update: If your application is using .NET, make sure to install .NET 4.0.2 or newer, as mentioned here. The original .NET 4 doesn't understand LocalDB connection strings, as it shipped long before LocalDB.

Related questions

How do I fix a "Performance counter registry hive consistency" when installing SQL Server R2 Express?

I'm trying to install SQL Server 2008 R2 Express from this site: http://www.microsoft.com/express/database/ I have a 64-bit, Windows 7 machine. I have tried both the 32-bit and 64-bit versions but each fail on "Performance counter registry hive …

Read More
Bootstrapping SQL Express from WiX?

I'm working on a WPF app, and using WiX as an installer. I'd like to start using SQL Express 2012, but want to resolve installer issues first. I'm looking for a full-up example of detecting, bootstrapping, installing, upgrading and uninstalling SQL …

Read More
SQL Server 2014 Express Set Up

I have downloaded Microsoft SQL Server Management Studio 2014 Express. I have set it up and I now need to connect to the server. I think my server name has something to do with my computer name but its not working. …

Read More