• Give More Feedback

Thandor.net - article. Information about the tool can. You can find links to the saved homepage and download for RSScripter at http://sqlserverfinebuild. Thandor.net - article. Information about the tool can. You can find links to the saved homepage and download for RSScripter at http://sqlserverfinebuild.

Give More Feedback

We have a SSRS 2008 (not R2) instance with a few hundred reports, and now, on a new machine we have installed a 2012 instance of SSRS. We need to migrate all the reports, while keeping all their rights and privileges, plus the datasources with credentials (some of them have local data sources). Is there a way to achieve this? The high number of reports does not allow us do it manually one by one.

We tried to migrate a report, but as I said, the rights and credentials were lost. Thank you in advance! Best is to use Reporting Services Scripter is a.NET Windows Forms application that enables the scripting and transfer of groups of SSRS catalog items from one server to another or from one SSRS folder to another on the same server. Reporting Services Scripter is flexible and lets you transfer catalog item properties, such as serverside report parameters, Subscriptions (both normal and data-driven), Descriptions, History options, and Execution options (including both report-specific schedule and shared schedule execution options) to other SQL Server instances. Kevin Kline highlights the functionality and there is a good article by Dale Kelly for migrating reports using RSScripter. Another way is to use the power of PowerShell. There are many script available like and.

There is other utility (which I have not used) called.