Good news, there are a several ways to do this, here is a list from low-level to high-level: Create a custom application consuming SSRS Web Services You can use Reporting Services web services to perform this task but I wouldn't recommend it unless you have specific needs which are not covered by other ways. The reason is that it would take some time, and there is no need to reinvent the wheel. There are 2 Web Services available, to manage Report Server items, you will need or depending of your Reporting Service instance. More details on how to consume these web services.
Anyone happen to have this tool handy? I used in the past to successfully migrate a 2005 SSRS instance to 2208 R2 and am in a similar boat now. Can someone please pass on a copy of RSScripter.
Manually Script You could write scripts (.rss) and import them with. This tool is based on the Web Services mentioned earlier. The rs.exe utility processes script that you provide in an input file.
Use this utility to automate report server deployment and administration tasks. Note that Sharepoint mode is supported with SQL Server 2008 R2+. Here is a MSDN article explaining that gives more details:. Use a tool to generate scripts This one is my favorite, several tools have been written to script items from a Server A and restore it to Server B, one of them is. You can find a tutorial on how to use it. Internally it uses RS.exe, the steps with the GUI are:.
Launch the RSScripter executable. Configure SSRS instance(s) in the Options. Click on 'Get Catalog' to display all the items of the instance. Select the items you want to script (Reports, DataSources, Policies.). Click on 'Script', this will generate a folder containing the selected resources (rdl, rss.), and a batch file. Edit the batch file with your new instance details. If applicable, move the directory to a place where your server is reachable.
![Download Rsscripter Tool Download Rsscripter Tool](/uploads/1/2/5/4/125495735/416027323.jpg)
Run the batch file and wait for completion. This can take time if you have a lot of reports, you can see the progress in the log file. There is also the from Microsoft, which seems to have some additional features, but I never tested it.