Ensure that you have IIS and dot net framework 2.0 is installed on report server.The script for loading the specified items will be generated to the specified folder. Select all the reports, data source, schedules and roles you want to transfer.Ĭhange the output directory path ( Should not be machine/user specific e.g.Select SQL 2005 from the Report Server dropdown and click on Get Catalog, all the reports, data source, Schedules, Roles etc present in report server will be displayed –.Change the SQL 2005 RS EXE Location in the Global tab as per the location of SQL server and Apply –.Click on Options, and select the options selected in images below( for more information about Scripting Options check the readme file – ) –.Update the servers.xml change the reportservice value if your ReportServer name is different.Download the Reporting Services Scripter –.If you are using SSRS then chances are high to come across a scenario where you want to deploy reports developed on development machine to the production server, there are various ways to do this and one of them is to use RS Scripter tool.
