April 26, 2005 at 4:29 pm
I accidently deleted my reports in the Production Reporting Service. How can I move or copy the same reports I have published on my Test Reporting Service to the Production. I cant event find the source rdl files. Is there a way we can do this in Reporting Service??
Thanks alot for your assistance
April 26, 2005 at 5:15 pm
this is probably not the fastest way, but on your Dev box, open report manager, go to the properties of a report, click the 'Edit' hyperlink, this should allow you to save the rdl to disk. Taking this rdl, open RM on the Prod box, click the 'upload file' button and then point to the recently downloaded RDL. You will need to do the same for data sources etc.
The above will take some time depending on the report count.
If you have more time with less criticality, try modifying one of the sample apps (the report manager type one, a winforms app) to let you save multiple rdls at once and them upload multiples at once. Alternatively, you could download them, create new VS projects and then publish them from VS again.
Lastly, (not my personally preferred option) you *could* try to do data copying from one DB to the other *but* any of the encrypted values are likely to not work as the encryption keys will be different on the two servers.
cheers,
Steve.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply