BizTalk.Deployment

2.1.22038.35776

Tasks/Tasks.Sql.ps1

                                #region Copyright & License

# Copyright © 2012 - 2022 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

task Deploy-SqlDatabases -If { -not $SkipSharedResources } `

   Invoke-SqlDeploymentScripts

# Synopsis: Undeploy SQL databases and execute SQL undeployment scripts

task Undeploy-SqlDatabases -If { (-not $SkipUninstall) -and (-not $SkipSharedResources) } `

   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 -Variable $_.Variable

      } finally {

         Set-Location $location

      }

   }

}

# Synopsis: Execute SQL undeployment scripts

task Invoke-SqlUndeploymentScripts -If { -not $SkipUninstall } {

   $Resources | ForEach-Object -Process {

      Write-Build DarkGreen $_.Path

      $location = Get-Location

      try {

         Invoke-SqlScript -Path $_.Path -Server $_.Server -Database $_.Database -Variable $_.Variable

      } 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]

      $Variable

   )

   $arguments = @{

      InputFile      = $Path

      ServerInstance = $Server

   }

   if (-not([string]::IsNullOrWhiteSpace($Database))) { $arguments.Database = $Database }

   # see https://stackoverflow.com/a/16656788/1789441

   if ($Variable.Keys | Test-Any) { $arguments.Variable = $( @($Variable.Keys | ForEach-Object -Process { "$_=$($Variable.$_)" }) ) }

   Invoke-Sqlcmd @arguments

}

# SIG # Begin signature block

# MIII0QYJKoZIhvcNAQcCoIIIwjCCCL4CAQExCzAJBgUrDgMCGgUAMGkGCisGAQQB

# gjcCAQSgWzBZMDQGCisGAQQBgjcCAR4wJgIDAQAABBAfzDtgWUsITrck0sYpfvNR

# AgEAAgEAAgEAAgEAAgEAMCEwCQYFKw4DAhoFAAQUvgrbrkIrsMWyFaljK/Iymltx

# qnqgggVMMIIFSDCCAzCgAwIBAgIJAJkr3mJdTBkUMA0GCSqGSIb3DQEBCwUAMEEx

# 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

# DAYKKwYBBAGCNwIBFTAjBgkqhkiG9w0BCQQxFgQUK9EnblhUsVhzwuWP/FBkIy2H

# P4wwDQYJKoZIhvcNAQEBBQAEggIAea/0K3lcFFSVzgwBJXeTqJt472ZEYWtQQ/bi

# D1YuIOU/F+Ft77er/Wn+YAqkzxGwmkrJ4yC13PQdyCv2GytgdgpUlXfQe/mI9HAo

# MuTekb9domU4x1OJ7aGZFCERBlSFfSdBBJYXMSZ4sMG/FTYuNyW7MHMlqbGWG+6Q

# WQ8xDrM+c6unW/FwBr5NQ42/WD1UPNA+b1KuinQvdzYNA6z/hLnbhCbR+LdfebQp

# FFf8HzbSQ7uMyQ/lC/BVL4wlHKc4F8Mki7wEhVO2SKdfN0lN+MZsslhwhVoRodSZ

# S54jK+MyLsWFsZ9VVb27Ked50KVRuAEUibtKeWZ7A4Ph70pd78dahRY3vHrc/8jP

# 6Zv/6iyLIa42QRZDccO6BYQYPhNpCV6yviHB1OCfoyyLr33VIyg9X5hYoQ89I01r

# EP3SntU0YkPJey1PV/Yn/+B20QxAWcmoV44a9ub4A2ljywCtaYQdQBoaHfZ9jyXt

# d/xD6qs+gAFy5F9jh2CeKqMuakMXKW4FYfUvrSHYloEgqxpTvup2Yh/MI6UQ9Pux

# EM/c3oPK+vjlo65B+qkE96g+KnYdXsHwE+kPE8OdRR/nfkOVkQjjkFTXycOBBKc/

# 4YWobutH5ucsTeO3VjnxuxjJ9LDT5/gs1Pev866vlI0p8tyOu/ts1/JFv+NsiL5H

# zZzYzO0=

# SIG # End signature block