Tuesday, February 28, 2012

SQL Server 2012 LocalDB, SQL Express, SQL Compact Edition, side by side table style...

Jerry Nixon - SQL Express v LocalDB v SQL Compact Edition

"LocalDB is created specifically for developers. It is very easy to install and requires no management, yet it offers the same T-SQL language, programming surface and client-side providers as the regular SQL Server Express. In effect the developers that target SQL Server no longer have to install and manage a full instance of SQL Server Express on their laptops and other development machines.

Localdb is a minified version of SQL Express that require less number of pre-req to install and offers a fast, zero-configuration installation. – Chirag Shah

In SQL Server "Denali" we decided to change the approach and introduce a dedicated version of SQL Express for developers - LocalDB that delivers the simplicity and yet is compatible with other editions of SQL Server at the API level.

LocalDBManager.exe was the original name of the tool. Just before shipping CTP3 we decided to change the name to SqlLocalDB.exe, since LocalDBManager.exe seemed a little bit over the top for a simple command line tool. "Manager" part of the name suggests something much more comprehensive than SqlLocalDB.exe, something like the old SQL Server Enterprise Manager or IIS Manager. - Krzysztof Kozielczyk

Also, by making LocalDB a better SQL Express for developers, we hope to be able to improve the regular SQL Express to be a better free SQL Server. We'd be very happy to hear your feedback in this area, especially if you're using SQL Express as a database server and find any issues caused by the new features that were introduced to fit the needs of developers and desktop environment.


Everything SQL Server Compact - Comparison of SQL Server Compact, SQL Server Express 2008 R2 and LocalDB

"Now that SQL Server Compact 4 has been released, some developers are curious about the differences between SQL Server Compact 4.0 and SQL Server Express 2008 R2.

I have updated the comparison table from the excellent discussion of the differences between Compact 3.5 and Express 2005 here to reflect the changes in the newer versions of each product.

Information about LocalDB comes from here and “Denali” CTP3 Books Online. LocalDB is the full SQL Server Express engine, but invoked directly from the client provider. It does not support Fulltext Search, and I doubt it support Merge Replication. It is a replacement of the current “User Instance” feature in SQL Server Express



While the chart is a few months old now, I still thought it outstanding seeing this kind of comparison, as I have the same questions, i.e. "What's the diff?" Now I'm in a better place... lol :)

I'm sure Erik will update this post (or create a new one) when SQL Server 2012 RTM's next month (March), so make sure you keep an eye on his blog...


Related Past Post XRef:
SQL Server Compact 4 vs SQL Server Express 2008 R2 Side-by-side feature comparison

Denali CTP3 introduces LocalDB - Think SQL Server Express crossed with SQL CE (or SQL CE grown up or SQL Express made as almost as easy CE)


Doug Kimzey said...

"LocalDB is created specifically for developers. It is very easy to install and requires no management"

This is all very well and good but no one seems to discuss actually building an install for an application that uses LocalDB. Do I simply add all of the files from the "..\Microsoft SQL Server\110\LocalDB\Binn" folder to the app folder in my install?

Is there a blog or reference that actually discusses building a WiX or InstallShield setup that includes LocalDB?

Greg Duncan said...

@Doug Kimzey
No, that would be bad. You need a bootstrapper for LocalDB



Also there's this stackoverflow that might help, http://stackoverflow.com/questions/9655362/localdb-deployment-on-client-pc

The search term to use is "deploy localDB" and/or "bootstrap localdb"

Hope this helps a little at least...