Reporting Services RS.exe script migrates content

Rating:        Based on 4 ratings
Reviewed:  4 reviews
Downloads: 4399
Released: Jan 8, 2014
Updated: Jan 8, 2014 by craigg
Dev status: Stable Help Icon

Recommended Download

Application ssrs_migration.rss
application, 39K, uploaded Dec 13, 2013 - 4399 downloads

Release Notes

Rs.exe is a command line utility included with SQL Server Reporting Services. This rss script supports copying content such as reports and data sources from one report server to another. The script supports both native mode report servers and SharePoint mode report servers. For example, you can use the script to copy content from a native mode report server to a SharePoint mode report server.

Basic Example, native mode report server to native mode report server:
The following example migrates content from the native mode Sourceserver to the native mode Targetserver.

rs.exe -i ssrs_migration.rss -e Mgmt2010 -s http://SourceServer/ReportServer -u Domain\User -p password -v ts="http://TargetServer/reportserver" -v tu="Domain\Userser" -v tp="password"


For detailed instructions and additional sample command line syntax, see the following article:
Sample Reporting Services rs.exe Script to Migrate Content between Report Servers

For more information on rs.exe, see the following:
rs Utility (rs.exe) (SSRS)

Reviews for this release

This worked like a charm to migrate 2008 R2 to 2014. It didn't copy encrypted data source passwords. Those were easy enough to input by hand.
by efesar on Jul 20 at 4:31 PM
Nice script. I have shared data sources in "/Data Sources" folder So i add code to function RelinkItemReferences if snkItem.Path = GetSnkPath(srcRef.Reference) then snkRef.Reference = GetSnkFilename(GetSnkPath(srcRef.Reference), type) Else If snkItem.Path <> GetSnkPath(srcRef.Reference) then snkRef.Reference = srcRef.Reference End If And it starts to work Exelent.
by viltaliy_lu on Feb 10 at 1:48 PM
Useful script. Worked like a charm
by spaghettidba on Dec 5, 2014 at 12:11 PM
Con este ejemplo he solucionado varias dudas .. muchas gracias
by sandrojaramillo on Sep 12, 2014 at 7:06 PM