In this recipe, we will connect to the LocalDB database.
LocalDB is a separate installation from your usual instance. LocalDB needs to be installed before you can follow this recipe.
You can download LocalDB with SQL Server Express from MSDN downloads at https://www.microsoft.com/en-ca/download/details.aspx?id=42299.
Let's take a look at the steps to connect to LocalDB:
Open PowerShell ISE as an administrator.
Import the
SQLPSmodule and create a new SMO Server object as follows:#import SQL Server module Import-Module SQLPS -DisableNameChecking
Add the following script and run it:
$instanceName = "(localdb)\MSSQLLocalDB" $server = New-Object -TypeName Microsoft.SqlServer.Management.Smo.Server -ArgumentList $instanceName #list all databases in localdb $server.Databases