Categories
Business Intelligence Geeky/Programming Product Reviews SQLServerPedia Syndication

Reporting Services Scripter: Sync Reporting Services Instances and Objects

The other day, I was tasked with moving all objects from one SQL Server Reporting Services instance to another. I know you can move the database itself, but then you run into issues with encryption keys etc. I just wanted to move the objects. I know that pretty much everything in SSRS is extensible, so I knew I could write something to do it, but before I went out and coded it, I Googled first to see if someone else had something. Turns out there is an awesome utility: Reporting Services Scripter. Works like a charm!

Technorati tags: , , ,

By Steve Novoselac

Director of Digital Technology @TrekBikes, Father, Musician, Cyclist, Homebrewer

3 replies on “Reporting Services Scripter: Sync Reporting Services Instances and Objects”

[…] If you have ever needed to extract the .rdl file from SQL Server Reporting Server, it’s not very easy. The physical .rdl (Report Definition List) is not stored anywhere on the server file system. It’s stored in the Catalog table inside Report Server. So, I am sure there are several ways to get this…but I was pressed for time and asked someone that I knew was a lot more knowledgeable on the subject. Steve gave me this link: Reporting Services Scripter […]

Like

[…] If you have ever needed to extract the .rdl file from SQL Server Reporting Server, it’s not very easy. The physical .rdl (Report Definition List) is not stored anywhere on the server file system. It’s stored in the Catalog table inside Report Server. So, I am sure there are several ways to get this…but I was pressed for time and asked someone that I knew was a lot more knowledgeable on the subject. Steve gave me this link: Reporting Services Scripter […]

Like

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 )

Google photo

You are commenting using your Google 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 )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.