Public/New-Instance.ps1
|
function New-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> New-SqlTestInstance ConnectionString DataSource ---------------- ---------- Data Source=(LocalDb)\MSSQLLocalDB;Integrated Security=True (LocalDb)\MSSQLLocalDB #> [CmdletBinding()] param () if ( Test-LocalDb ) { Get-LocalInstance | Write-Output } elseif ( Test-Docker ) { New-DockerInstance -AcceptEula | Write-Output } else { Write-Error 'No SQL server provider like Docker or LocalDb is available.' } } |