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?