Public/Get-Instance.ps1
|
function Get-Instance { <# .SYNOPSIS Returns connection parameter for a SQL server. .DESCRIPTION Checks different versions of local db or creates a Docker container with a SQL server installed. Returns a object with the properties DataSource and ConnectionString. .EXAMPLE PS> Get-SqlTestInstance ConnectionString DataSource ---------------- ---------- Data Source=(LocalDb)\MSSQLLocalDB;Integrated Security=True (LocalDb)\MSSQLLocalDB #> [CmdletBinding()] param () if ( Test-LocalDb ) { Get-LocalInstance | Write-Output } else { Write-Error 'No SQL server provider like LocalDb is available.' } } |