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)] [ValidateNotNullOrEmpty()] [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 # AgEAAgEAAgEAAgEAAgEAMCEwCQYFKw4DAhoFAAQUPtoh5dbE0XKH7F6myeMjeJtQ # 0+qgggWhMIIFnTCCA1GgAwIBAgIQKBOAjgMDO55A7UJ/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 # MBwGCisGAQQBgjcCAQsxDjAMBgorBgEEAYI3AgEVMCMGCSqGSIb3DQEJBDEWBBR0 # r8VelwAFw9+S7SnBsaY+3j3YeTANBgkqhkiG9w0BAQEFAASCAgA6QCpo9t/XOAhZ # 5cjTG0SaFXqjl9Gr35tsZxlrQBD76IyL6rFR4oAZqi2zyZfaTkyAgSxV+v2vrN/d # t3JduHUhyIsje7KGQ0nyyp2P79tYmAJvtwXljaGXBDFO5hjpwOQOIXMQlhaSxOqL # ZMmSS/qODHC2lhN6NZ6pj9SunobNpT/sCdYl1twSdnZ6+yJt/DpygK6EAT6GGC9i # orIPEvSxbXtN9hlEFnu+akyIwJ26SP9FbIJCTL8Xmckt5GwBSznxL3klY2umkEll # 0mDO1lGTOi1rf1XtUkAc3lnFbIg8899xlUQm7zppXJeuRpvjoX6ztlH8xEyy/hBP # UDZY5kw7B4hEIuhjTk6AgNca5kTZG2LluP2DK+kE6tVDJpbfYqoCxkIB8kqFg3ix # VJOBJPyUzpEy0rAjXWNI+2IxO57e3W9lmI+sMvgJMfrRU5XBrre9dIq5Rat1D4EW # d5J9kCg++1neIN9gNwS2foQARnf5JN3aOqUFaXPuHjTynlluBNY7+v9qQvluB4zJ # aiqqQzD13wDjlKkbyvkPrb14nO5ILTY2bJSFQ0Xkd9EIyTOUDp+8u+lOYqS0rFON # 5l1zQaBtwUElo+gj7tVmd5nQRxJWpWNWJLR9Vfkw4kj1MajYMX5e0S2Y3PiCio4t # 6QF76k0gvLlfSFZ2xF/g89J2N/y/dQ== # SIG # End signature block |