Migrating SSRS reports to new instance of SQL Server 2008
Hi All,
I want to migrate SSRS reports to new Report Server (similar configurations as the old box).
The migration should move everthing from the existing report server like:
1.Reports from Report Manager
2.Subscriptions
3.Linked Reports
4.Data Sources
5.Schedules
6.Folders
7.Models
8.RDL's
9.Roles
10. Catalogs
etc.
Can any one suggest me the best solution please?
Has any one used Reporting Services Scripter available at (sqldbatips.com) , any comments please?
Thanks and regards,
Rafiq
October 10th, 2011 5:26pm
Hi Rafiq,
You can move the Report Server database to the new server - http://technet.microsoft.com/en-us/library/ms156421.aspx
When you move your ReportServer database, all your reports, security etc will be moved as well. The ReportServer stores Reports,
data sources, report models, folders, subscriptions and schedule definitions etc
Hope this helps!
Free Windows Admin Tool Kit Click here and download it now
October 10th, 2011 5:31pm