Public/New-DockerInstance.ps1
|
function New-DockerInstance { <# .SYNOPSIS Returns connection parameter for a SQL server in a new Docker container. .DESCRIPTION Creates a Docker container with a SQL server installed. Returns a object with the properties DataSource and ConnectionString. .EXAMPLE PS> New-SqlTestDockerInstance -AcceptEula Name : Sandbox Hostname : localhost UserId : sa ConnectionString : Server='localhost';Encrypt=False;User Id='sa';Password='pa$$w0rd' IsDocker : True Id : 693d5e79169c50af4ab5b10e1af9069a987ec8902033f3c55f325e12199a61c1 Names : {Sandbox} Image : mcr.microsoft.com/mssql/server Command : "/opt/mssql/bin/permissions_check.sh /opt/mssql/bin/sqlservr" LocalVolumes : {0} Labels : {com.microsoft.product=Microsoft SQL Server, com.microsoft.version=15.0.4153.1, vendor=Microsoft} Mounts : {} Networks : {bridge} Ports : {0.0.0.0:1433->1433/tcp} CreatedAt : 2021-12-01 00:00:00 +0100 CET RunningFor : 2 seconds ago Status : Up 1 second Size : 0B (virtual 1.54GB) DatabaseCredential : System.Management.Automation.PSCredential #> [CmdletBinding( PositionalBinding=$false )] param ( # Specifies the name of the new Docker container. [Parameter()] [string] $DockerContainerName = ( ( New-Guid ).ToString().Substring(0, 8) ), # Specifies the password for the sa user. [Parameter()] [ValidateNotNullOrEmpty()] [string] $ServerAdminPassword = 'Pa$$w0rd!', # Confirms your acceptance of the [End-User Licensing Agreement](https://go.microsoft.com/fwlink/?linkid=857698). [Parameter( Mandatory )] [switch] $AcceptEula, # Specifies the seconds to wait for the SQL service. [Parameter()] [int] $Timeout = 30, # Specifies the port to map the sql server to. [Parameter()] [int] $Port = 1433 ) Import-Module psdocker -MinimumVersion 1.7.0 -ErrorAction Stop if ( -not $AcceptEula ) { throw "Accept the Microsoft EULA with -AcceptEula" } $osArch = ( Get-DockerVersion -ErrorAction Stop ).Server.Engine.OSArch Write-Verbose "Create $osArch container." $dockerParameter = Get-SqlDockerParameter -OsArch $osArch # create container $container = New-DockerContainer ` -Image $dockerParameter.Image ` -Name $DockerContainerName ` -Environment @{ 'ACCEPT_EULA' = "Y" $dockerParameter.ServerAdminPasswordVariable = $ServerAdminPassword } ` -Ports @{ "$Port" = 1433 } -Detach -ErrorAction Stop # await the service Invoke-Expression "$( $dockerParameter.WaitCommand.Name ) -Name '$( $container.Name ) -Timeout $Timeout'" -Verbose # add metadata $container | Add-Member 'Hostname' 'localhost' $container | Add-Member 'DataSource' 'localhost' $container | Add-Member 'Port' $Port $container | Add-Member 'UserId' 'sa' $container | Add-Member 'SecurePassword' ( ConvertTo-SecureString $ServerAdminPassword -AsPlainText -Force ) $container | Add-Member 'ConnectTimeout' 30 $container | Add-Member 'ConnectionString' "Server='$( $container.Hostname ),$( $container.Port )';Connect Timeout=$( $container.ConnectTimeout );Encrypt=False;User Id='$( $container.UserId )';Password='$ServerAdminPassword'" $container | Add-Member 'IsDocker' $true $container | Add-Member 'DatabaseCredential' ( New-Object System.Management.Automation.PSCredential ($container.UserId, $container.SecurePassword) ) # return $container | Write-Output } |