PS script for updating the Connection string value in SSRS shared data sources

Update-SSRS_Datasources

$OldSource = 'MySQLServer-01'
$NewSource = 'MySQLServer-02'
$URL = 'http://ReportServerName/ReportServer/ReportService2010.asmx?wsdl'

$URI = New-Object System.Uri($URL)
$SSRS = New-WebServiceProxy -Uri $URI -UseDefaultCredential
$DataSources = ($SSRS.ListChildren("/data sources", $true)).path

ForEach($Source in $DataSources){

    $DS = $SSRS.GetDataSourceContents($Source)
    
    IF($DS.ConnectString -like "*$OldSource*"){
        $String = $DS
        $String.ConnectString = $String.ConnectString.Replace($OldSource,$NewSource)
        $SSRS.SetDataSourceContents($Source,$string)
    }
}