Home > Reporting Services > How to Copy Reporting Services Reports off a Reporting Server and Production Deployment

How to Copy Reporting Services Reports off a Reporting Server and Production Deployment

Every now and then in my travels around SSRS I have needed to do this. You may be unsure if the version of the report deployed to production is the version of the report in source control and just want to get latest off the production server.

The way I have normally had to do it is to connect to the Reporting services server, go to the properties of the report and then choose “Edit” or in SQL Server 2008 R2 choose “Download”.

If you have to do this for alot of files this is painful, until now…

I found this tool the other day, and I must say its awsome.

http://www.sqldbatips.com/showarticle.asp?ID=62, its called the “Reporting Services Scripter” and I have a new friend.

Not only can it extract files from a given server if you have the correct credentials, it will also create a deployment script.

So now the pain of releasing files to production one by one can be avoided and having to manually configure things again and again.

This is all scripted into a batch file that can then tweaked to point to the production server and this can then all be wrapped up neatly into a release.

Nice 🙂

Advertisements
Categories: Reporting Services
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: