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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics