Blogs

.NET to SQL to Project Server and everything in between
Welcome to Blogs Sign in | Join | Help
in Search

Strate SQL

Scripting Out Reports

While trying to deploy reports a while back I was lamenting the process of manually creating scripts to load reports to the production.  This is, of course, the better than using Visual Studio to deploy reports, since it is possible that the RDL in your project may have changed since deploying the report to the QA or Dev environment and the tested report is the one that needs to move to production.

Thankfully, I don't have to worry about this too much any longer.  SQLDBATips has a great tool that automates creating these deployment scripts.  Their Reporting Services Scripter does everything that is needed, from downloading the RDL to getting the subscriptions. 

I've used it a couple times now and the only issues I've had with it is having to go in and change the Reporting Services Server so that it references the server that I am planning to deploy to.  Big whoop, that's definitely better than writing all of the scripts myself.

Do check it out, it very nice.

Published Thursday, September 13, 2007 11:56 AM by Jason
Filed under:

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

No Comments

Leave a Comment

(required) 
(optional)
(required) 
Submit
Powered by Community Server, by Telligent Systems