Replace DB connections

changedb.ps1

Param
(
       
        [string]$ServerHostName,
        [string]$User,
        [string]$Password,
        [string]$DBName,
        [string]$GeoServerDataDir
      
)

# find all datasource.xml files in X:\workspaces

foreach($datastore in (Get-ChildItem "$GeoServerDataDir\workspaces\" -Include "datastore.xml" -Recurse)){

# replace user, host and password
$xml = [xml](Get-Content $datastore.FullName)
$xml.dataStore.connectionParameters.entry | where {$_.key -eq "user"} | % { $_."#text" = $User } 
$xml.dataStore.connectionParameters.entry | where {$_.key -eq "host"} | % { $_."#text" = $ServerHostName } 
$xml.dataStore.connectionParameters.entry | where {$_.key -eq "passwd"} | % { $_."#text" = $Password } 

# if not OS Master maps switch DB
if(($xml.dataStore.connectionParameters.entry | where {$_.key -eq "database"})."#text" -ne "osmm"){
  $xml.dataStore.connectionParameters.entry | where {$_.key -eq "database"} | % { $_."#text" = $DBName } 
}

# save the file
$xml.Save($datastore.FullName)

}