SQL Express LocalDB - Expressly for developers
Written by Kay Ewbank   
Wednesday, 24 August 2011
Microsoft has rather quietly introduced a new version of SQL Express, created specifically for developers.

The new version, SQL Express LocalDB, provides the same T-SQL, programming surface and client-side providers as the regular SQL Server Express, but is designed to be easier to manage. This means that if you want to write an app that runs against SQL Server you no longer have the hassle of installing and managing a full instance of SQL Server Express. It is also intended to work well as an embedded database.

sqlserverexpress

The thinking behind this move, according to the SQLExpress blog, is that SQL Express is being used for two distinct needs. On one hand it is a free edition of SQL Server, where would-be users of the full version can learn how to install, manage and program in a way that is 100% compatible with other editions.

In the case of developers writing applications targeting SQL Server, though, the programming aspects need to be identical, but you don't really want the extras to make it compatible in terms of management and administration. Because of this, in SQL Server "Denali" Microsoft decided to change the approach it 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.

It uses the same sqlservr.exe as other editions of SQL Server, you use the same client-side providers (ADO.NET, ODBC, PDO etc) to connect to it, and you can operate on its data using T-SQL. It doesn't create any database services; LocalDB processes are started and stopped automatically when needed. When an application tries to connect to LocalDB, the provider checks whether the LocalDB instance for the current user is started. If it's already started the application will connect to it, if not the LocalDB instance for the current user will be started and then the provider proceeds to connect to it.

The blog makes clear that LocalDB is not a replacement for SQL Server Express -- it is an addition to SQL Server Express lineup. While LocalDB is meant for developers, the regular SQL Server Express will continue to exist as a free SQL Server edition.

More Information:

Introducing LocalDB, an improved SQL Express

 

Banner


IBM Launches IoT Foundation
21/10/2014

Just about everyone you can think of wants a slice of the Internet of Things pie and now IBM has placed its best bet for securing its IoT profits in the future - the IBM Internet of Things Foundation. [ ... ]



Block H and Colossus Revisited In Virtual Reality
24/09/2014

Block H at Bletchley Park, built in September 1994 specifically to house the Colossus computers, was the world's first purpose built computer centre. To mark its 70th anniversary Colossus veterans wer [ ... ]


More News

Last Updated ( Wednesday, 24 August 2011 )
 
 

   
RSS feed of news items only
I Programmer News
Copyright © 2014 i-programmer.info. All Rights Reserved.
Joomla! is Free Software released under the GNU/GPL License.