Copy Report Server configuration -- sql server reporting services

Alex
1/24/2006 4:16:29 PM

Hi,

Is it possible to copy reports and data source definitions, roles and
subscriptions from one SSRS server to another? Currently we have an
installation of SQL Server 2000 Reporting services with many reports in it.
I have setup a new server with SSRS 2005 and would like to move all SSRS
2000 configuration and reports to the SSRS 2005.

Thanks in advance

Jasper Smith
1/24/2006 10:18:07 PM

Reporting Services Scripter (link below) should be able to help with the
bulk of it. There are certain shortfalls regarding having to manually supply
passwords for shared data sources using stored credentials and subscription
owners that can't be done via the web service API but it should do the bulk
of it for you. Do let me know if you run into any issues or have any feature
requests.

http://www.sqldbatips.com/showarticle.asp?ID=62

--
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com

[quoted text, click to view]

sql server reporting services : Copy Report Server configuration