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


HeartBleed - The Programmers View
10/04/2014

You've heard about the HeartBleed vulnerability in OpenSSL, you probably have had to deal with its consequences - but perhaps you don't know just how old fashioned a bug it is. 



MariaDB 10 Available
10/04/2014

The stable version of MariaDB 10 has been released with better performance and new features. One major change is support for data in non-relational databases courtesy of the new Connect engine.


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.