BizTalk.Deployment

1.0.21005.34296

Tasks/Tasks.Sql.ps1

                                #region Copyright & License

# Copyright © 2012 - 2020 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 Invoke-SqlDeploymentScripts

# Synopsis: Undeploy SQL databases and execute SQL undeployment scripts

task Undeploy-SqlDatabases -If { -not $SkipUndeploy } Invoke-SqlUndeploymentScripts

# Synopsis: Execute SQL deployment scripts

task Invoke-SqlDeploymentScripts {

    $Resources | ForEach-Object -Process {

        Write-Build DarkGreen $_.Path

        $location = Get-Location

        $arguments = @{

            InputFile      = $_.Path

            ServerInstance = $_.Server

        }

        if ($_.Variables.Keys | Test-Any) { $arguments.Variable = $(Format-SqlVariable -Variable $_.Variables) }

        try {

            Invoke-Sqlcmd @arguments

        } 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

        $arguments = @{

            InputFile      = $_.Path

            ServerInstance = $_.Server

        }

        if ($_.Variables.Keys | Test-Any) { $arguments.Variable = $(Format-SqlVariable -Variable $_.Variables) }

        try {

            Invoke-Sqlcmd @arguments

        } finally {

            Set-Location $location

        }

    }

}

function Format-SqlVariable {

    [CmdletBinding()]

    [OutputType([string[]])]

    param (

        [Parameter(Mandatory = $false)]

        [ValidateNotNullOrEmpty()]

        [hashtable]

        $Variables

    )

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

    @($Variables.Keys | ForEach-Object -Process { "$_=$($Variables.$_)" })

}

# SIG # Begin signature block

# MIIJEgYJKoZIhvcNAQcCoIIJAzCCCP8CAQExCzAJBgUrDgMCGgUAMGkGCisGAQQB

# gjcCAQSgWzBZMDQGCisGAQQBgjcCAR4wJgIDAQAABBAfzDtgWUsITrck0sYpfvNR

# AgEAAgEAAgEAAgEAAgEAMCEwCQYFKw4DAhoFAAQUcgQePQGEOdD6YXW/6j80R521

# 85ygggWhMIIFnTCCA1GgAwIBAgIQKBOAjgMDO55A7UJ/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

# MBwGCisGAQQBgjcCAQsxDjAMBgorBgEEAYI3AgEVMCMGCSqGSIb3DQEJBDEWBBTw

# Yzru7vwkPjvdQ0WU1QdGIPMCljANBgkqhkiG9w0BAQEFAASCAgAv+EyQOxYnnbV+

# hD2XO8w+ixOLw/gVmMk9o3+LuZrNrmXdjW7mokp1S82e6lB+U3MW3OMw0ZULGdhl

# 26+l27WAKnkSwBJjSWFZlYjm7C+sSxThegIvIr59uYC/fmcnmcZCca9m/gU9fIWr

# ZfN4+UDzUA4IQsXLGwvucnf7HgYNltav15Bo+cPSjIh9GS11Qq9C0gO3pMDrjLHY

# t+to7X3ss0kE0bHLKfZ0AJk/DbJ0nUOF3yjhbM6J7RQqEIuMdIH8opQlo3nqfcZV

# N4WDsE8DnvsAaYtruJ0uDpSoibr/McwDuut1HjrtgUJ1RemKNvwotnkjJrnHW5If

# eCRKl2J/i0knMX71ENw219ZSXDS8e7lvlOaiBBKyu8HzRuNpV+RZgP2ncAkZXq/h

# ENeUG2bcJJLNec/r0RB7Q6MZbrqA+1O94wt0uMW9QHLideTqekOHfZydzEplZsYD

# vKYLx7sf7X3ZSUwOZMTrNRfuWQdyQR1/pgrAwCvSiFlwLoM7zsNE00XC6IAu5UMF

# Sh67HqapQNzpDvJXmOFu6/6XKdv6O0ZYBhBMtP6KJQjE1jzpZVKTDETD6unU9z4N

# lv0e3yPdW62OkMoUqgmeEmjKXOeRwZPntWDmD3aWaGVGXtik5SehxsEPrnJ51KJu

# L1H3x7UeGkmosKRvEKaLZ0GjO89TUA==

# SIG # End signature block