SQLLocalDB

sqllocaldb is a command line tool for managing localdb instances.

C:\>sqllocaldb info
MSSQLLocalDB

sqllocaldb info MSSQLLocalDB

C:\>sqllocaldb info "MSSQLLocalDB"
Name:               mssqllocaldb
Version:            13.1.4001.0
Shared name:
Owner:              PC1\romeo
Auto-create:        Yes
State:              Stopped
Last start time:    4/6/2022 1:31:56 PM

create database instance

sqllocaldb create "v11.0"

use sqlcmd to query database instance

sqlcmd -S "(localdb)\MSSQLLocalDB"
1> use <database name>
2> go


sqlcmd -S "(localdb)\MSSQLLocalDB" -d <database name>
1> select * from <table name>

run sq script file

sqlcmd -S "(localdb)\v11.0" -i "script.sql"

sqlcmd -S "(localdb)\MSSQLLocalDB" -i "script.sql"

sqlcmd -S "(localdb)\MSSQLLocalDB" -i "script.sql" -o "C:\Users\user\Documents\GitHub\sqllocaldb\output.txt"

sqlcmd -S "(localdb)\MSSQLLocalDB" -i "script.sql" -o "C:\Users\user\Documents\GitHub\sqllocaldb\output.txt" -e "C:\Users\user\Documents\GitHub\sqllocaldb\error.txt"

sqlcmd -S "(localdb)\MSSQLLocalDB" -d <database name> -i "script.sql"

EXEC sp_cmdshell 'sqlcmd -S "(localdb)\MSSQLLocalDB" -d ' + @DBName +' -i ' + @scriptFilePath