search

msspurlock / reportsync

Automatically exported from code.google.com/p/reportsync
1 stars 0 forks source link

Not An Issue, A Question #21

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
Can this be used to bulk load RDLs to a new server, without having saved first 
from an old server? Our old SSRS server got wiped out (I didn't do it!), but 
the reports remain in the ReportServer database (at least, I think they do, no 
way of knowing). 

However, when a new SSRS re-installed and configured on the same machine, the 
guy couldn't remember what password he had used to backup the encryption keys, 
so he went ahead and created new ones. I don't know enough about SSRS to even 
know if we can salvage those reports that already exist in the ReportServer 
database, but I'm thinking probably not because of the different encryption now.

I have all the reports in a Visual Studio project, so I can upload them all 
again via the ReportManager, but I thought it might be easiest if I could find 
some way to bulk-upload them and maybe your utility might be good for that.

Any advice?
~~Bonnie

Original issue reported on code.google.com by DeWitt.B...@gmail.com on 8 Apr 2013 at 4:06

GoogleCodeExporter commented 9 years ago 
Losing a server is always painful. No, this tool is not meant for that. 
It can bulk load rdls from our SSRS server to another without having to save 
them in between. But your old server needs to be up and running for that. 

You can still get the reports out of the database. Here is one blog post that 
can get you started: 
http://bretstateham.com/extracting-ssrs-report-rdl-xml-from-the-reportserver-dat
abase/. After the rdls are extraced, then you can use reportsync to upload them.

But if you have the orignial reports in Visual Studio, it would be easiest to 
upload directly from there. If you deploy the project, all your reports should 
get uploaded without much effort.

Original comment by nunespascal on 8 Apr 2013 at 4:22

GoogleCodeExporter commented 9 years ago 
Thanks for your prompt reply!

I'm still having other issues with that new SSRS installation and the guy who 
knows more about SSRS than I do isn't available to trouble-shoot that, so I'm 
stuck having to figure it out. But ... that's another story!

Thanks for the link to Bret Stateham's blog post. It looks interesting and 
might even be useful (but, maybe not for this purpose, dunno yet).

I will continue to muddle through. Thanks for your input!

Original comment by DeWitt.B...@gmail.com on 8 Apr 2013 at 5:18