SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


How To COPY SSRS Folder ??


How To COPY SSRS Folder ??

Author
Message
Jeff-67583
Jeff-67583
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1201 Visits: 290
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
Gift Peddie
Gift Peddie
SSCoach
SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)

Group: General Forum Members
Points: 17048 Visits: 14456
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
maddogs
maddogs
Mr or Mrs. 500
Mr or Mrs. 500 (544 reputation)Mr or Mrs. 500 (544 reputation)Mr or Mrs. 500 (544 reputation)Mr or Mrs. 500 (544 reputation)Mr or Mrs. 500 (544 reputation)Mr or Mrs. 500 (544 reputation)Mr or Mrs. 500 (544 reputation)Mr or Mrs. 500 (544 reputation)

Group: General Forum Members
Points: 544 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
htt
htt
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1244 Visits: 862
worked like a charm!

thx.



shashu2310
shashu2310
Grasshopper
Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)

Group: General Forum Members
Points: 19 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
Raj-398988
Raj-398988
Grasshopper
Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)

Group: General Forum Members
Points: 15 Visits: 4
This is an awesome tool. Works like a charms. Thanks to the creator.
Diane Rayzer
Diane Rayzer
SSC Rookie
SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)

Group: General Forum Members
Points: 32 Visits: 146
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
call.copse
call.copse
SSCertifiable
SSCertifiable (5.6K reputation)SSCertifiable (5.6K reputation)SSCertifiable (5.6K reputation)SSCertifiable (5.6K reputation)SSCertifiable (5.6K reputation)SSCertifiable (5.6K reputation)SSCertifiable (5.6K reputation)SSCertifiable (5.6K reputation)

Group: General Forum Members
Points: 5582 Visits: 2008
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search