问从Reporting Services迁移到SSDT

EN

Import-Module SqlServer

$targetReportDirectory = "c:\temp\rs" #where to put the files

If (-Not (Test-Path $targetReportDirectory)) {new-Item -Path $targetReportDirectory -ItemType directory -Force}

#recreate directory structure on disk
Invoke-Sqlcmd -ServerInstance localhost -Database ReportServer -Query "Select Path from [Catalog] Where Type = 1 and Nullif(Path, '') is not null --Folders" | ForEach {
    $localpath = Join-Path $targetReportDirectory $_.Path 

    If (-Not (Test-Path $localpath)) {$f = new-Item -Path $localpath -ItemType directory -Force}

}


#pull all reports down
$ReportPortalUri = "http://localhost/Reports"
Invoke-Sqlcmd -ServerInstance localhost -Database ReportServer -Query "Select ItemID, Path from [Catalog] Where Type = 2 and Nullif(Path, '') is not null --Reports" | ForEach {

    $catalogItemsApi = $ReportPortalUri + "/api/v1.0/catalogitems($($_.ItemID))/Content/`$value"
    $response = Invoke-WebRequest -Uri $catalogItemsApi -Method Get -UseDefaultCredentials
    $downloadPath = Join-Path $targetReportDirectory $($_.Path + ".rdl")
    [System.IO.File]::WriteAllBytes($downloadPath, $response.Content)

}