sql/Deploy-CustomDatabases.ps1
|
Import-Module "$PSScriptRoot\Sql-Module.psm1" Import-Module "$PSScriptRoot\..\common\Utils-Module.psm1" $ErrorActionPreference = "Stop" Write-Host "Deploying custom databases started..." if ($global:Configuration.sql.customDatabases.Count -lt 1) { Write-Host "No custom databases found." } else { $sqlServer = $global:Configuration.sql.serverName $sqlUser = $global:Configuration.sql.username $sqlUserPassword = $global:Configuration.sql.password $sitecoreInstallDir = $global:Configuration.sitecore.installDir foreach ($db in $global:Configuration.sql.customDatabases) { $dacpac = $db.dacpack $localDbUserName = $db.loginUsername $connStrName = $db.connectionStringName $dacpackName = [System.IO.Path]::GetFileNameWithoutExtension($db.dacpack) $targetDatabaseName = "$($global:Configuration.prefix)_$dacpackName" DeployDacpac -SqlServer $sqlServer -Username $sqlUser -LocalDbUsername $localDbUserName -Password $sqlUserPassword -Dacpac $dacpac -TargetDatabaseName $targetDatabaseName AddConnectionString -SqlServer $sqlServer -Database $targetDatabaseName -Username $localDbUserName -Password $sqlUserPassword -WebsiteRootDir $sitecoreInstallDir -ConnStringName $connStrName } } Write-Host "Deploying custom database done." |