none
Copy reports to a different folder on Report Server

    Question

  • My report server has 2 folders: ProductionReports - about 50 reports AND TestReports - 0 reports

    I want to copy all the reports from Production to Test. One method is to save each Prodcution .rdl then upload each one to Test and then change its datasource. This will take a long time!!!! Is there a way and can copy them all together and then go change their data source? I am hesitant to deploy the reports from VS because I don't know if the project has the correct report versions (it is not my server).

    Is there an easier way to do this? Thanks!!!! Linda

     

     

     

    Tuesday, September 28, 2010 5:48 PM

Answers

  • There is a Cool tool that someone created just to do this!  It works great just make sure you read all the information or else you can modify your production environment.  It's called RSScripter and i use it all the time.  It saves TONS of time!!

    here's the link  (and it's free!)

    http://www.sqldbatips.com/showarticle.asp?ID=62

    • Proposed as answer by pmp07 Tuesday, September 28, 2010 7:04 PM
    • Marked as answer by Jerry NeeModerator Friday, October 08, 2010 11:58 AM
    Tuesday, September 28, 2010 7:04 PM

All replies