Public/New-SqlServer.ps1
|
function New-SqlServer { <# .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-SqlServer ConnectionString DataSource ---------------- ---------- Data Source=(LocalDb)\MSSQLLocalDB;Integrated Security=True (LocalDb)\MSSQLLocalDB #> [CmdletBinding()] param () $localDb = Get-LocalDb -ErrorVariable localDbError -ErrorAction SilentlyContinue if ( -Not $localDbError ) { Write-Output $localDb } else { New-DockerSqlServer -AcceptEula | Write-Output } } |