Reporting Services - Copy Report Folder

Posted on 2011-10-14
Last Modified: 2012-05-12
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?
Question by:holemania
    LVL 21

    Accepted Solution

    LVL 21

    Expert Comment

    by:Alpesh Patel
    Generate script as per step in article and update the script file for folder name and execute on same server

    Author Comment

    Thank you so much.  That helps a lot.

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Join & Write a Comment

    Introduction In the following article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting Services 2008 R2 CTP, more precisely version 10.50.1352.12, but the methods ex…
    Hello, In my precious Article  ( saw the Configuration part for Microstrategy which included Metadata Creation and DataSource Preparation as …
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now