Reporting Services RS.exe script migrates content

Rating:        Based on 6 ratings
Reviewed:  5 reviews
Downloads: 7260
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 - 7260 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

Im migrating SSRS 2008 R2 To SSRS 2012. Everything worked like a charm... but.. when i used the switch SECURITY = TRUE , only the items's role was moved. The system's role (on the 2012 server side) was erased by the script (and replaced by the last one on the 2008 source server side). Is there a way to keep the system's role on the 2012 server side? Thanks, Dung-Anh
by dunganh on Jan 6 at 8:29 AM
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, 2015 at 3: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, 2015 at 12:48 PM
Useful script. Worked like a charm
by spaghettidba on Dec 5, 2014 at 11:11 AM
Con este ejemplo he solucionado varias dudas .. muchas gracias
by sandrojaramillo on Sep 12, 2014 at 6:06 PM