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

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

Other recent topics Other recent topics