Connect to localdb using Sql Server management studio
Posted
by Magnus Karlsson
on Geeks with Blogs
See other posts from Geeks with Blogs
or by Magnus Karlsson
Published on Sun, 18 Nov 2012 09:23:29 GMT
Indexed on
2012/11/18
11:05 UTC
Read the original article
Hit count: 439
I was trying to find my databse for local db under localhost etc but no luck.
The following led me to just connect to it, kind of obvious really when you look at your connections string but.. its sunday morning or something..
From: http://blogs.msdn.com/b/sqlexpress/archive/2011/07/12/introducing-localdb-a-better-sql-express.aspx
High-Level Overview
After the lengthy introduction it's time to take a look at LocalDB from the technical side. At a very high level, LocalDB has the following key properties:
- LocalDB uses the same sqlservr.exe as the regular SQL Express and other editions of SQL Server. The application is using the same client-side providers (ADO.NET, ODBC, PDO and others) to connect to it and operates on data using the same T-SQL language as provided by SQL Express.
- LocalDB is installed once on a machine (per major SQL Server version). Multiple applications can start multiple LocalDB processes, but they are all started from the same sqlservr.exe executable file from the same disk location.
- LocalDB doesn't create any database services; LocalDB processes are started and stopped automatically when needed. The application is just connecting to "Data Source=(localdb)\v11.0" and LocalDB process is started as a child process of the application. A few minutes after the last connection to this process is closed the process shuts down.
- LocalDB connections support AttachDbFileName property, which allows developers to specify a database file location. LocalDB will attach the specified database file and the connection will be made to it.
© Geeks with Blogs or respective owner