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 # MIII0QYJKoZIhvcNAQcCoIIIwjCCCL4CAQExCzAJBgUrDgMCGgUAMGkGCisGAQQB # gjcCAQSgWzBZMDQGCisGAQQBgjcCAR4wJgIDAQAABBAfzDtgWUsITrck0sYpfvNR # AgEAAgEAAgEAAgEAAgEAMCEwCQYFKw4DAhoFAAQUPsV6FAm6ceMhkgliEjF8JaQm # 7KqgggVMMIIFSDCCAzCgAwIBAgIJAJkr3mJdTBkUMA0GCSqGSIb3DQEBCwUAMEEx # PzA9BgNVBAMeNgBpAGMAcgBhAGYAdABzAG8AZgB0AHcAYQByAGUAQABzAHQAYQB0 # AGUAbABlAHMAcwAuAGIAZTAeFw0yMTA2MjUxNDEyMjNaFw00MTA2MjAxNDEyMjNa # MEExPzA9BgNVBAMeNgBpAGMAcgBhAGYAdABzAG8AZgB0AHcAYQByAGUAQABzAHQA # YQB0AGUAbABlAHMAcwAuAGIAZTCCAiIwDQYJKoZIhvcNAQEBBQADggIPADCCAgoC # ggIBAOeqdUHBv7sxSeX3aj6yPKj7PAvs8izpVXjyEBl5aR8mQneVcXuF53AH7EW1 # 6E5p4+Az5pJPGUD5c3tXhiGMF7vgLhQjO6hlaVBRIqiIYHikNLwMNy6YBMc/QQYM # rPhqHEFsZ53dkBIIj3M8e3kFcTFA09n25yDtTPDab4nd9yUhc9Qc8+nfpIzfYsoP # 1pZ3nCzhw6hN2/44v1dkQrG3dRYwt+px65p6NPNZWEJpt4VCJjIFh+lBYJdxm9d4 # X/rAnlHIkbv7liOavWDzgHVabS3hdAWtcDmynm+7+FcZDFqPWNCl3e4SS7xe4s/R # CKFKA0IsfKkSk9YJlLgeSQIEXUOOWXJAGaLqnRD8xWLZsc4Oi9GZg7XV1mv/S88c # oztXnwtAN3OOlRKBh2QbomMgxeMO0GvsLE/cq5Q/YKAoz+KGr/7LcZq9jzQ8IPus # ZvWLeDXmxPiwJjpZc1koLgfGIEX2NStQTT3QmacWr9thrWcKvI+4uBmI4exS9B4a # R3nV91w5EY+2RoYsHqej9LWwNamO96+jMX9pxprTX+EkLUuMAikw/po8sBC9MUUn # 5pMWmUv7DCtQOLGGBDDMMMkn4ZcjpCEEdPGHRKfqNnD27ssGtDjiNzfQrsm67toU # bBwUF+gyJq/YckWquYJhA9ZOFWEADuIwGnsOzsoRvuQyY+p9AgMBAAGjQzBBMA4G # A1UdDwEB/wQEAwIHgDAWBgNVHSUBAf8EDDAKBggrBgEFBQcDAzAXBgNVHREEEDAO # ggxzdGF0ZWxlc3MuYmUwDQYJKoZIhvcNAQELBQADggIBACithYM3qckZRc9+Xbfu # a6gWr3HwjrW+FHKgjfrcOm8ZnLVapb9xFqsqrRQqd3RXWQDINEGrtI2rSfrzyfoK # UiTgldIfQNP1ZcGY229d++90t3hdo2mlt05hjYlbMENloJHpsEP0vQZmwOcEimCT # ex1pymYM+P9pj3j8UD1PT1eIZot6or8fBRl63UybyDSrM7L4UOkkAOniKxWy5pW6 # 6duS8SR+SZpr3Bv44NyXPj0Nv+MIpLmsLrd7XPBFmnGxzY01ZO9vzi9KEhM2wT5i # jPqHDNOvfPiADtAa+EyUBzdJiqy9heCz/TMZQgMWGwtfqJNxWZmsHcha2anW4Qt+ # mzrLO4GojWoVog9uVSAq+l0a+YQsd1u1kUmm4vgZCFyUA+lEp4LkI7ca2VBHkLPD # w+u2DoDMRiqFPZjO7BCKjGc0jj9B/qGR3JVt+tqDdB621xXf2YGF2oFvxZQ/keGt # 0ujfJ+JwN3nCulDAA4773q6KUnfykyrvAgITNbRJL6TngeRKtw9VIJBPxzqMzLpV # 5ggXNituwLaD1CCBJ1oo9DZHpL9gplXp1wGrelJOTiJhh+pdNsPtRH7CrranWa5h # LFLuigqin0eewQ5giJ1VaiBVEseOmiZog+27UpFIv40aDzgGL3YxB/Mu0ojwrQtp # WLmqJCmWnR5qxOm0yK+zNWe0MYIC7zCCAusCAQEwTjBBMT8wPQYDVQQDHjYAaQBj # AHIAYQBmAHQAcwBvAGYAdAB3AGEAcgBlAEAAcwB0AGEAdABlAGwAZQBzAHMALgBi # AGUCCQCZK95iXUwZFDAJBgUrDgMCGgUAoHgwGAYKKwYBBAGCNwIBDDEKMAigAoAA # oQKAADAZBgkqhkiG9w0BCQMxDAYKKwYBBAGCNwIBBDAcBgorBgEEAYI3AgELMQ4w # DAYKKwYBBAGCNwIBFTAjBgkqhkiG9w0BCQQxFgQUBdBvzh8zpbBPH8OxhTC+D9+w # m20wDQYJKoZIhvcNAQEBBQAEggIATDP4iDzxKM9qNZmWYjJP7ywhsQ0+zSO7HlC+ # w0/6i8SG+lqaNJFXMYCduXtlRi4jyeaCcKNLKQhCZzHGvGAB0FNgBOppZVNFA0YE # rF2+vPN0xkFBbFwrWiVpwjUFpv4tQeF9sLqojyQrA0ghoOSxckO/xPY1gVEbdkn3 # xTpFy4XE7eqNu6AriH1MzEOKsA7Z6xDRpIqCs+9Hulvs0j3e+vC7Oi5P9FUln69q # 5iwbBJRJAkBqv+4UZg5GcXuatoVURoGQAUy2wlSSiB6JTlDHQyNy3yDn2kK0S7+L # uC2FWLc/2GSHLXwRn4v4xy5fa82HIqkmEhK2CKx2FuaYrVzk3b0/X4MhzEAx6rck # 55pFi1+RrCOXmB+K/Bku2yEhTdTVNs1GGIJiBWH4ijqV+e/I1MU855AsF+ySGyzK # +1WXZkGks9zbXPpiuayciC71xfezn+qhaFnucH9mz4PJTeIXmXvnINo9+U46EDRC # YuTCOK55x/X8Gj8AswDd2ZyCDne7BbRahnN+vuaDEB5D/R8dfoTMiSl/N/saulp9 # tD7IkO/28n5nvrLipXgm61K57uoX6O4jOJzUa2RAal8/2cP1vryik0P3SyKqlIvx # 6Yt0IRK0SiTnQQ3GfH/DRI76RzLfUzDYtq0i4rSGiecXVwY63Szx1GYG3WD9Z523 # WveD6GU= # SIG # End signature block |