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: Reporting Services, SQL Server 2005 Reporting Services, Reporting Services Scripter, SSRS
Steve Novoselac's Blog 
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 […]
LikeLike
[…] 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 […]
LikeLike
Give report sync a try too. http://code.google.com/p/reportsync/
Its a small little utility I wrote to do the same job.
LikeLike