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


VLOGGER - AI Does Talking Heads
24/03/2024

Developed by Google researchers VLOGGER AI is a system that can create realistic videos of people talking and moving from a single still image and an audio clip as input. 



We Built A Software Engineer
20/03/2024

One of the most worrying things about being a programmer today is the threat from AI. It has gone so far that NVIDA CEO Jensen Huang proclaims that you really shouldn't start training as a programmer  [ ... ]


More News

Last Updated ( Wednesday, 24 August 2011 )