Deploying Reports

[Ridyen]

We have implemented both a development and production reporting services server but I cannot find information on how to move (deploy) reports from the development server to the production server. How is this typically done or is considred best practice just to allow report creators the ability to deploy to the production environment?

Any thoughs appreciated. Thanks.

 

[nomadicalloy]

use this tool to transfer reports from one server to another

http://www.sqldbatips.com/showarticle.asp?ID=62

My Programming Blog

http://www.xpherion.com/wp/index.php/category/programming/

 

[Ridyen]

Thanks. I actually found this tool before your response and used it to generate the scripts. However I get an error every time I try to configure the tool. It indicates that the field it is trying to update does not exist. I may try contacting the folks that wrote the tool to see if they can tell me what's going on.

 

[nomadicalloy]

I have a older version of this tool that I know it works. I customized for my environment. I can share that version with you if need it.



My Programming Blog

http://www.xpherion.com/wp/index.php/category/programming/

 

[Ridyen]

Thanks for the offer but I managed to get the tool working. Not sure how but the config file got corrupted. I copied the original config file back in, pointed it to my servers and all works great. Overall a great little tool.

 

[xlbo]

No real need to be honest - simply change the "Destination" property of your VS project to point to the live server as opposed to the dev one

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[Ridyen]

True but our developers do not have publish rights to the production server. Got to watch the sneaky little devils you know.