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 3: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 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: 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 7:47am

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 7:56am

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 : Regards, Vikram Kansal
Free Windows Admin Tool Kit Click here and download it now
January 25th, 2011 9:07am

I just voted for this as well... RSScripter is great, but when you have to deal with file to disc subscriptions (outside of DDS), scripter looses the PWD for those file to disc subs.... I have to remember to run a small script that will update the .VB code to add this in... Major pain if you happen to forget...
December 29th, 2011 3:35pm

Looks like everyone's wishes are being granted. Right now it's limited to moving between Native Mode and SharePoint mode, but it's a start.John
Free Windows Admin Tool Kit Click here and download it now
April 26th, 2012 10:24am

Thanks John for pointing this out. A start yes...dont know why they limited to native to sharepoint mode migration only....Kind Regards, Vikram Kansal Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
May 4th, 2012 7:27am

Supporting native -> native and SharePoint -> SharePoint migration is in the plans ... :)
Free Windows Admin Tool Kit Click here and download it now
June 4th, 2012 4:52pm

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

Other recent topics Other recent topics