- New products for SQL Server 2012
- SQL Sever Express Lightweight version
- Switch to developer creation
- No management
- concurrently in T-SQL language
- The programming interface is the same as SQL Server Express
- Suitable for small application environments, embedded environments
Benefit: No more laptop installations to maintain a large instance of SQL Server. Characteristics:
- is compatible with other versions of SQL Server, using Sqlservr.exe as a service process, using the same client access interface, and compatible with the T-SQL programming language.
- There is no need to install multiple localdb, and different programs can execute multiple LOCALDB processes in parallel, all starting from sqlservr.exe.
- does not create any system services, and the LOCALDB process automatically starts and stops as needed. The application only needs to link data Source = (localdb) \v11.0. He will start as a child process of the application, the link terminates, and the process terminates. The
- supports the AttachDbFileName property, which allows the developer to set the database file location, for example:
data source< Span class= "Apple-converted-space" > = (localdb) \v11.0; &NBSP;
Integrated security = True &NBSP;
attachdbfilename = c:\mydata\database1.mdf
Not a substitute for express, knowledge is fun for developers. Another option differs from the SQL Server Compact: The Compact is an in-process dll,localdb is a standalone process disk footprint: Compact is only 4MB, The LocalDB features 140MB functionality: The compact provides only RDBMS core functionality, while LocalDB offers richer features such as stored procedures, geometries, and geographic data types.
SQL Server LocalDB Learning Note 01 Introduction