Reporting Services Reports Migration
Hi ,
Apart from the RSScripter is there any plans from microsoft to release a tool in the future which can be used to deploy reports/security etc from one report to another. This will be very useful for administration purposes. I believe BO also has a similar
tool probably named as Life cycle manager.
Regards,
Vikram
September 9th, 2010 10:52am
Hi Vikram,
The built-in function to move reports from SQL Server Reporting Services(SSRS) 2008 to SSRS 2008 R2 is migrating the installation. Migrating the SSRS installation will move all reports, subscriptions, security settings or other configured settings to the
new installation.
However, there is no built-in GUI tools that help us to move reports to the SSRS 2008 R2. I would suggest you submitting a wish
https://connect.microsoft.com/sql. If the service requests frequently, we may include it in the next release.
Anyway, as far as I know, the RSScripter should be the best third-party tool to move reports to new instance currently.
For more information, please see:
How to: Migrate a Reporting Services Installation:
http://msdn.microsoft.com/en-us/library/ms143724.aspx
If you have any more questions, please feel free to ask.
Thanks,
Jin Chen
Free Windows Admin Tool Kit Click here and download it now
September 9th, 2010 2:47pm
Hi Jin,
Thanks for your reply. I will submit it as a wishlist.
BTW, I was referring to moving reports from one environment to another i.e from DEV to UAT and UAT to Prod etc. For people who manage Report Servers it is a great advantage as they dont have to go through backing up restoring the database if they have to
copy lot of reports from one environment to another. Also in a normal support scenario where you want to restrict developers access this kind of a tool will be immensly helpful for the support team.
Regards,
Vikram
September 9th, 2010 2:56pm
Anyone who is interested in getting a utility from MS which gives you the ability to copy reports from one environment to another or within the same environment then please vote here :
https://connect.microsoft.com/SQLServer/feedback/details/596425/reporting-services-report-migration-utility-tool
Regards,
Vikram Kansal
Free Windows Admin Tool Kit Click here and download it now
January 25th, 2011 3:14pm