Post reply

Export Data Sources only

  • July 31, 2017 at 5:25 am

    #332000

    I've set of a Proof of Concept server for SQL 2016 and I'd like to move just the data sources to the new server.
    I've tried using the ReportSync.v1.1.2 tool but it crashes. Are there any powershell scripts available to do this?

    Thanks in advance

  • August 8, 2017 at 7:46 pm

    #1954552

    smitty-1088185 - Monday, July 31, 2017 5:25 AM

    I've set of a Proof of Concept server for SQL 2016 and I'd like to move just the data sources to the new server.
    I've tried using the ReportSync.v1.1.2 tool but it crashes. Are there any powershell scripts available to do this?

    Thanks in advance

    If you use the ReportingServicesTools module, you export data sources using something like:
    Out-RsFolderContent -ReportServerUri 'http://YourReportServer/reportserver' -RsFolder /'Data Sources' -Destination C:\Temp

    You could also iterate through a folder with Get-RsCatalogItems, iterate through, filter and export with Out-RsCatalogItem. This link has an example:
    Functions/CatalogItems/Out-RsFolderContent.ps1

    Searching on either of those cmdlets will find examples.

    Sue

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply