[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 625
  • Last Modified:

Reporting Services - Copy Report Folder

I have a folder that contains over 100 reports.  I need to copy this folder to another folder to work and point it to a different database.  So basically copy the folder to a new folder and rename the data source to look at new database.  So I don't want this affecting the production reports.  

Is there an easy way for me to copy folder A to a new folder B?  I can move files, but that's not what I want to do.  I can also link the reports from A to B, but then I want to separate this so that when I change the data source, it's not affecting the production reports.

Can the RS utility be use for this?  If so how woudl I go about copying one folder into another within the same reporting server?
  • 2
1 Solution
Alpesh PatelAssistant ConsultantCommented:
Generate script as per step in article and update the script file for folder name and execute on same server
holemaniaAuthor Commented:
Thank you so much.  That helps a lot.

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now