how to migrate or copy SSRS datasource from one server to another without restoring the report server

8.5k Views Asked by At

I'm trying to migrate SSRS report from SQL 2008r2 to SQL 2014 server. I used reportsync to transfer the report to the server. the reports are successfully transferred but however the roles subscriptions and datasources are not transferred. Is there is any way to copy or migrate the data sources, roles and subscription from one server to another without restoring the report server database?. Thanks.

1

There are 1 best solutions below

2
On

I have used these migration tools which doesn't help me much. i found the below link after a lot of struggle trying different things

https://azuresql.codeplex.com/releases/view/115207

https://msdn.microsoft.com/en-gb/library/dn531017.aspx#bkmk_how_to_use_the_script

better to test reports and subscription after migrate finish