Hi All,

I am here to write a simple article to move SSRS reports from one server to another. When I have faced the same issue to move reports those were developed by developer on development server and now need to be moved on production server. I have tried many ways to move report to productions server. But, all are routine work to publish from BIDS to server. However, I need the easy way to move all reports from Development to Production server.  After long time googling I found the best industry freeware tool on sqldbatips.com.

The Tool is developed by Microsoft MVP (Jasper Smith).

Let's move on tool and see the features of Tool.

Tool is available with User Interface and Command-line application.

First set the Parameter for Application before use for Report transfer. It shows useful checkboxes which objects you want to export from server. The application export all objects like folder, Datasource, reports, dataset etc.

You can see the generated script as shown in image.

To move reports to another location move this files to destination server (Optional)
Just edit the file (RS Scripter Load All Items.cmd) and set the path of script and destination server name save it and execute.

It will load all the objects to the destination server.

It is over for the now. Let me know if you have any question.

Thanks,

Alpesh