SqlLocalDb

README.md

Know Issues

Problem with localsystem

Localdb Automatic intances

MSSQLLocalDB
v12.0

(localdb)\ProjectsV12 instance is created by SQL Server Data Tools (SSDT) (localdb)\MSSQLLocalDB is the SQL Server 2014 LocalDB default instance name (localdb)\v11.0 is the SQL Server 2012 LocalDB default instance name Localdb Manual instances

"C:\Program Files\Microsoft SQL Server\110\Tools\Binn\SqlLocalDB.exe" create "v11.0" 11.0 -s
"C:\Program Files\Microsoft SQL Server\120\Tools\Binn\SqlLocalDB.exe" create "v12.0" 12.0 -s
"C:\Program Files\Microsoft SQL Server\130\Tools\Binn\SqlLocalDB.exe" create "v13.0" 13.0 -s
"C:\Program Files\Microsoft SQL Server\130\Tools\Binn\SqlLocalDB.exe" create "MSSQLLocalDb" -s 

Localdb Manual instances

SqlLocalDb c Test
 
 
SqlLocalDb start Test
 
 
C:\>SqlLocalDb info test
Name: Test
Version: 12.0.4213.0
Shared name:
Owner: LS\nordine
Auto-create: No
State: Running
Last start time: 27.10.2015 09.59.03
Instance pipe name: np:\\.\pipe\LOCALDB#2B506018\tsql\query
 
 
C:\>sqlcmd -S "(LocalDB)\Test"
1> select name from sys.databases
2> go
        name
        --------------------------------------------------------------------------------------------------------------------------------
        master
        tempdb
        model
        msdb
        (4 rows affected)
1>quit
 
 
SqlLocalDb stop Test
 
 
SqlLocalDb d Test