Learn PowerShell Core 6.0

Exporting content

There are really two core aspects to working with data in Reporting Services: exporting and importing content. There are better tools out there for authoring reports. Where automation – and thus PowerShell – really shines, however, is moving SSRS data from one SQL instance to another; thus, exporting and importing content really is the bread and butter of this module, and there are solid commands out here to facilitate just this.

On the export side, the two important commands are Out-RsCatalogItem (for individual or filtered items) and Out-RsFolderContent (for bulk export):

# Export /Foo/Example to the current pathOut-RsCatalogItem -RsItem /Foo/Example -Destination .# Export all Data Sources in /FooGet-RsFolderContent -RsFolder ...