July 6, 2009 at 8:51 pm
Hi,
I need to move the SQL Server 2005 Reporting Services reports from one server to another server.
Is there any script / method available.
Please let me know.
Balavenkatesh
July 7, 2009 at 12:20 am
i think you will have to open your reports project in BIDS, go to the project property pages and change the TargetServerUrl to your new server and re-deploy your reports. For example, if your reports are hosted on "server1" then you probably have the TargetServerUrl as "http://Server1/ReportServer", in this case you need to change the TargeServerUrl to "http://Server2/ReportServer" and re-deploy.
July 7, 2009 at 12:23 am
Hi,
Thanks for your reply. I have more than 100 reports. Is there any other method other than BIDS Please specify.
Balavenkatesh
July 7, 2009 at 12:41 am
I'm not sure if there is another method but may give a look to these links
http://msdn.microsoft.com/en-us/library/ms156421.aspx
http://www.sqldbatips.com/showarticle.asp?ID=62
http://kevinmarquette.blogspot.com/2007/04/migrating-sql-reporting-services-2005.html
July 8, 2009 at 5:47 am
One option is to backup the ReportServer database on the source server and then do a restore to your destination server. You'll need to backup the encryption key on the source as well and then apply it to the destination after the restore or you'll need to reenter and passwords for your data sources.
Be aware that any subscriptions will also be coped over so if you don't want those on the destination, you'll need to remove those manually as well.
July 8, 2009 at 9:35 am
Did anybody try this?
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply