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 -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 -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)] [ValidateNotNull()] [hashtable] $Variables ) $arguments = @{ InputFile = $Path ServerInstance = $Server } # 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 # AgEAAgEAAgEAAgEAAgEAMCEwCQYFKw4DAhoFAAQUZ+IJNLRAQtE2B5AmrgS+T1La # MT+gggWhMIIFnTCCA1GgAwIBAgIQKBOAjgMDO55A7UJ/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 # MBwGCisGAQQBgjcCAQsxDjAMBgorBgEEAYI3AgEVMCMGCSqGSIb3DQEJBDEWBBQ/ # 2JKVcJD3qwBDFIX4J10jmPcBQDANBgkqhkiG9w0BAQEFAASCAgCNMJWqg/3TDSC9 # kX22F9BXvdCr8jfshpA2DKjo5meHjOf0Q7FFn5g0+d6W7qS5vVo/zg8+ZJtWD4oX # wMA9HAJbzt42aCxcgqHqPeh0OvOLFXie1kyd1lUDCNanzS66z4WLSxcToTbamxu+ # YkPqiXPva1j85+uy29XkWKWZsCdwZCkDpNSU8MKjZWe0daZTN3Wz8Z/C91zJDWbK # fHyTYogtYhevXwgLitMdFYDzBDl8AAYvLHZ88yn1Za+mOmC5b8932l4Di/TiBL17 # ITPHgdPfE4KwSJyThJOGD88NcsGj37ypTXnYuMD7fLDTETKQgSplrm+mN0PobIMP # Ab7fHIWZMl5NGA12PFBK93lxkBz0wdJbm6fj3AS50FUZMxA+kBYwqUa2/iRwj/dQ # iX3cjCDT5o919XPz/YZBkOTZb9nH6Lqe1CUKFg/V95mz46bu6WsIRCT0dWZhFE0C # 82styIeKn6MGtj1++TMj5LJtjr0Y7S/RgWcx4ADROSsbOF2mWPnOso6cGO8t8W8M # iZgZG66V0/9CtOrWGFGe36yhQKt61vQMZnrdOBZgrSiBXtGHAx0JiI0fnJtE9Oao # R1g5uevwzLgW1hqkTN3hqAj5S4gK7ClAHN30GPX8i/zNXWOBmZoFEJqZcsYfd6z3 # oXwCgoD9kh7E1azbgB2gm12G0/JwBA== # SIG # End signature block |