Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How To COPY SSRS Folder ?? Expand / Collapse
Author
Message
Posted Tuesday, January 15, 2008 8:15 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 8:14 AM
Points: 247, Visits: 231
Hello,

MSSQL2005/SP2 w/SSRS

We have created folder levels ie: MyReport\DEV and MyReport\PROD using SSRS web admin tool. Our developers have built & uploaded several reports into the MyReport\DEV folder. We would like to copy them now to MyReport\PROD, but under properties, all we see is "Apply", "Delete" and "Move". We are trying to mimic a DEV and PROD environment similar to out IIS environments.

Is there a way to copy these reports?

Thanks. Jeff


Many thanks. Jeff
Post #443034
Posted Wednesday, January 16, 2008 7:08 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Wednesday, October 15, 2014 2:32 PM
Points: 3,428, Visits: 14,439
I don't copy folders I just copy the RDL and all the related solution files which is very important because when changes are made most times only the solution files changes. SQL Server reporting services reports are the easiest to send to others I have emailed and given them to other people in net meeting. This means you move one report at a time and make sure it runs before you move others. This is assuming all your three databases are running the datasource database, reportserverdb and reportservertempdb.



Kind regards,
Gift Peddie
Post #443617
Posted Thursday, January 17, 2008 10:12 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, August 15, 2013 6:15 PM
Points: 110, Visits: 730
Check out a free tool - Reporting Services Scripter- at http://www.sqldbatips.com.
Yous can set it up to create RS scripts to move\copy SSRS reports, folders, permissions, whatever between severs or on same server.



maddog
Post #444438
Posted Thursday, January 17, 2008 3:28 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: 2 days ago @ 11:29 PM
Points: 447, Visits: 571
worked like a charm!

thx.



Post #444645
Posted Friday, February 5, 2010 12:09 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, February 5, 2010 12:07 PM
Points: 1, Visits: 2
Hi,

I selected the script only option and now I want to copy reports on different folder on the same server?
Can you please tell me how did you do that?

Thanks
Shashank
Post #860754
Posted Wednesday, March 10, 2010 10:54 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, March 21, 2013 1:23 PM
Points: 1, Visits: 3
This is an awesome tool. Works like a charms. Thanks to the creator.
Post #880435
Posted Thursday, July 15, 2010 3:23 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, November 27, 2013 10:08 AM
Points: 11, Visits: 117
Hi Everyone:

Can someone help me... I'm trying to use the free product Reporting Services Scripter (2.0.0.17). I installed it made sure the id that I was using on the existing report server is a local administrator. Actually it's a local administrator on both servers (the existing one and the one I'm transferring the reports to).

As soon as I hit the transfer button I get the following error, it doesn't even give me a message that it's creating the scripts:

"The permissions granted to user "xxxxxx" are insufficient for performing this operation. Can somone who has used this product please let me know what I may be doing wrong, or tell me what ID your using or if I need a permission that I may not have.

I also want to edit and mention I get the error when I want to copy the datasource... it will execute when I try model or data model but I get an error saying the datasource is not there.

Your help is greatly appreciated.. Thank you
Diane
Post #953508
Posted Friday, February 21, 2014 5:21 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 2:48 AM
Points: 1,733, Visits: 1,143
Just adding that this tool saved me a lot of time recently - thanks Jasper plus the folks suggesting it above.

I had to download it from the link below, as sqldbatips is no longer running:
http://web.archive.org/web/20120830141644/http://www.sqldbatips.com/showarticle.asp?ID=62

cheers,
Iain
Post #1543933
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse