Reporting Services Scripter: Sync Reporting Services Instances and Objects
Aug.25, 2007 in
Geeky/Programming, Product Reviews
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
Simlar Posts
- SSRS Exporting Report to Excel - Keep Formatting on Export Round 2
- SSRS and SSAS Formatting Dates
- SQL Server 2005 - Reporting Services - Windows Vista
- Business Intelligence and Analysis Services in the "Real World"
- Reporting Services: Can’t Uninstall - The setup failed to read IIsMimeMap table. The error code is -2147024893
February 5th, 2008 at 4:45 pm
[...] 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 [...]
February 5th, 2008 at 4:45 pm
[...] 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 [...]