Tasks/Tasks.Sql.ps1
|
#region Copyright & License # Copyright © 2012 - 2021 François Chabot # # Licensed under the Apache License, Version 2.0 (the "License"); # you may not use this file except in compliance with the License. # You may obtain a copy of the License at # # http://www.apache.org/licenses/LICENSE-2.0 # # Unless required by applicable law or agreed to in writing, software # distributed under the License is distributed on an "AS IS" BASIS, # WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. # See the License for the specific language governing permissions and # limitations under the License. #endregion Set-StrictMode -Version Latest # Synopsis: Deploy SQL databases and execute SQL deployment scripts if on the Management Server task Deploy-SqlDatabases -If { -not $SkipMgmtDbDeployment } ` Deploy-SqlDatabasesOnManagementServer # Synopsis: Deploy SQL databases and execute SQL deployment scripts task Deploy-SqlDatabasesOnManagementServer ` Invoke-SqlDeploymentScripts # Synopsis: Undeploy SQL databases and execute SQL undeployment scripts if on the Management Server task Undeploy-SqlDatabases -If { -not $SkipMgmtDbDeployment } ` Undeploy-SqlDatabasesOnManagementServer # Synopsis: Undeploy SQL databases and execute SQL undeployment scripts task Undeploy-SqlDatabasesOnManagementServer -If { -not $SkipUndeploy } ` Invoke-SqlUndeploymentScripts # Synopsis: Execute SQL deployment scripts task Invoke-SqlDeploymentScripts { $Resources | ForEach-Object -Process { Write-Build DarkGreen $_.Path $location = Get-Location try { Invoke-SqlScript -Path $_.Path -Server $_.Server -Database $_.Database -Variables $_.Variables } finally { Set-Location $location } } } # Synopsis: Execute SQL undeployment scripts task Invoke-SqlUndeploymentScripts -If { -not $SkipUndeploy } { $Resources | ForEach-Object -Process { Write-Build DarkGreen $_.Path $location = Get-Location try { Invoke-SqlScript -Path $_.Path -Server $_.Server -Database $_.Database -Variables $_.Variables } finally { Set-Location $location } } } function Invoke-SqlScript { [CmdletBinding()] [OutputType([void])] param ( [Parameter(Mandatory = $true)] [ValidateNotNullOrEmpty()] [string] $Path, [Parameter(Mandatory = $true)] [ValidateNotNullOrEmpty()] [string] $Server, [Parameter(Mandatory = $true)] [AllowEmptyString()] [string] $Database, [Parameter(Mandatory = $true)] [ValidateNotNull()] [hashtable] $Variables ) $arguments = @{ InputFile = $Path ServerInstance = $Server } if (-not([string]::IsNullOrWhiteSpace($Database))) { $arguments.Database = $Database } # see https://stackoverflow.com/a/16656788/1789441 if ($Variables.Keys | Test-Any) { $arguments.Variable = $( @($Variables.Keys | ForEach-Object -Process { "$_=$($Variables.$_)" }) ) } Invoke-Sqlcmd @arguments } # SIG # Begin signature block # MIIJEgYJKoZIhvcNAQcCoIIJAzCCCP8CAQExCzAJBgUrDgMCGgUAMGkGCisGAQQB # gjcCAQSgWzBZMDQGCisGAQQBgjcCAR4wJgIDAQAABBAfzDtgWUsITrck0sYpfvNR # AgEAAgEAAgEAAgEAAgEAMCEwCQYFKw4DAhoFAAQUPsV6FAm6ceMhkgliEjF8JaQm # 7KqgggWhMIIFnTCCA1GgAwIBAgIQKBOAjgMDO55A7UJ/k/g5nTBBBgkqhkiG9w0B # AQowNKAPMA0GCWCGSAFlAwQCAQUAoRwwGgYJKoZIhvcNAQEIMA0GCWCGSAFlAwQC # AQUAogMCASAwJjEkMCIGA1UEAwwbaWNyYWZ0c29mdHdhcmVAc3RhdGVsZXNzLmJl # MB4XDTIwMDYyMzExNDM1NloXDTIxMDYyMzEyMDM1NlowJjEkMCIGA1UEAwwbaWNy # YWZ0c29mdHdhcmVAc3RhdGVsZXNzLmJlMIICIjANBgkqhkiG9w0BAQEFAAOCAg8A # MIICCgKCAgEAmQcb0GwlBHBHBJZ9vNM8EewN7T+nhsWVU0WBoWnIw6UAT99Rw9x5 # RcfOQU2hxqKmR1k+iI6B+qddpTC3VLSChA/mh1P4pCDDsZeyR/0nn/r/DezhDe8x # 5jckjR88KSRcgDoh0kLjgfrToDpx9EvBcwXmNJKDwBIWu5SBvk04beU4XO7OHjBo # g0kMaHxCZc9HcWfdzBefP+fbVzu6f1j1WgEqZn9sr1ML2ulHRdu26+56xGq9RZGJ # vXyY1mY+K5mqBcET+1bV2pZnBrM3Gc/hlmvTkwrC0ZGBALLZWZqqpLVrDCY5eoHP # w2C0kA4JzK4Q1o218s+wXbuDcjYRIZqBSwI8fizR/4DS+6dEjfa3kzs2z/MrkJOk # hJ06tiMSRr55tX1DR8NwVLdiNqZYvs4zP2ZNRMMI8uFCjkP/Wn1hfBr+GSPlgdLq # 2TFishY2pj5O1WlE/tCz+B0YLhPWdfbVEp8kB3fGBsVf7uw4STK/wDA1MYRIHikt # w+K9gtdf0eIR9dYX9CMwoDN2TNLK6vnCWMrzWFe5EOU3/oljUBkyQT838a5A6wMu # cGeu7Cwjdigylt7ULaTglL7ORIyaRbzkltxd+1oaQ21kjl4ef0ZD2gWLj7bwrZR+ # KWCfmaHFoZlVRKNPtScuyOnilPGGZ6T7SNuwVxSXFRtbp+cQea4UxxUCAwEAAaNf # MF0wDgYDVR0PAQH/BAQDAgeAMBMGA1UdJQQMMAoGCCsGAQUFBwMDMBcGA1UdEQQQ # MA6CDHN0YXRlbGVzcy5iZTAdBgNVHQ4EFgQUq4sCoE2IqN4K4uwNuibjqd5yNNQw # QQYJKoZIhvcNAQEKMDSgDzANBglghkgBZQMEAgEFAKEcMBoGCSqGSIb3DQEBCDAN # BglghkgBZQMEAgEFAKIDAgEgA4ICAQBR98amLpANKFlc7mPlkaV4ZtS2uTmbJ6dO # qzyWKJ2yTmv7U9yq8PdEH9mPJlxYvGyNgxqHoocKv1SdjgYh27SM8pDnsfU2NpER # 6K/3sICy6Orh9vhC+U18Bp93WoLEezolaBcF0co3/o+HazOvs/2zBFONFHMkef9/ # 3Bipm0sd95teHo53vLKViHbjSmoGxYsvJJiYITB4Zeo6xgUAmwcUpL1To62Lb3RP # CDLKZQ5h8Ir07nncV4HLq+0qF3+G9Y0IXHJv6Qcr/XTTLo0J877HRqS37WJcgF8+ # 2nbZbqO9NVvp14A4nTqpeDFmzewDU33hiZvzuLHBj//OgLgGZ9lJPxCu0tVxfFWZ # INHg1YHp3lMaAw00Q3tb/vhc5kE6Kl7FnXnUTsu4j+vUoaFMWhYezoyn9m4rD+xN # RITrbLPZdWAZvVOJ8ehmswRhfiMZ1npwbrk7KU1UTsmMS7PHREWSyUM28WlMFf2i # ut8TlY/MV/adUGr2GpqBWhxp5DRgfl1uamKm2wFlCra3/kReVlQgC/Bbod2JOgJW # t8zCbO4nJx+fJYwM9RG70h/TmuqzP8uChsHtKcgs2YtXmSm12JZakXY4IflInI7p # ddDEs9UOfsWXDsqpvmFQZbwgGeNeEsPk3Fdm1MzDtS9PBXMk4jGGXNzEsVUgwf42 # 2HuDWeX/4jGCAtswggLXAgEBMDowJjEkMCIGA1UEAwwbaWNyYWZ0c29mdHdhcmVA # c3RhdGVsZXNzLmJlAhAoE4COAwM7nkDtQn+T+DmdMAkGBSsOAwIaBQCgeDAYBgor # BgEEAYI3AgEMMQowCKACgAChAoAAMBkGCSqGSIb3DQEJAzEMBgorBgEEAYI3AgEE # MBwGCisGAQQBgjcCAQsxDjAMBgorBgEEAYI3AgEVMCMGCSqGSIb3DQEJBDEWBBQF # 0G/OHzOlsE8fw7GFML4P37CbbTANBgkqhkiG9w0BAQEFAASCAgBIarBdEZbh+xhE # ShxAqqMWWpzRncStq5C7OBOT6XcbmCJ6LsFunbekuxatyMtRgAVrc+LI6T3Mk56H # xbNktRBx4PP4KLk14M+v5z3pkdkG3oLfJcXbnVuzFTDXjpsjhinqPefhv+pnCHjU # qM9IQxoyUqw4YqoywCj+HIlwMBF4sMQbCHsmUWoTZfU94doxidB3WXzSBk3gRRAt # itmblTZHoc2wIX2EEuTCkKLmOtqEMZyvEMmLHAFgm7gcLAII8+/W37tuxLIJCop/ # oUlGOzZejtAFm9MlW9vKhPCE6I+O+UndsicItsUcp//Urosne8QeEXWXggw/KHVX # W3MetU/a31lAoGT7NkHRJcbnLYaWzu4XPxkdxXJRHt3j35MFs0Dc/tyuUvQka7zM # gqudguQ+WHDgSiFT9XwadItYxXZX1Us3JcyZSjFnr/Jp8T46Xx8d5nL/qu71rqZv # sYuNSwxQvTOeHPkALa+p8Bmry47w+5h2O2fcsYRqcWGMYbQsyGbfB7mN7fpXJrGi # XX/JdtMMVWePaAznKN8EwlvTHe8RwN0UN+adStvkSCV9d8QNN5hzGByDwCMqIydG # PaK7Zflpm9Dpn7vu6J5bpZcJLDIa8E3M5VlNsb/UBjELYWzvP2QGqtnK28XAsc2h # d8BqYnd3zc+hFRgI2CGGoGK0ub8KHQ== # SIG # End signature block |