I am scheduling some reports locally in my system. How can I copy this schedule information to remote system to avoid re-doing of scheduling at remote system?
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
migrated from stackoverflow.com Feb 1 '12 at 14:07
This question came from our site for professional and enthusiast programmers.
Use the "Reporting Services Scripter" which uses the web service API of SSRS to migrate stuff. I'm not sure how up to date it is, last updated 2009 However, I've foundthis useful in previous jobs.
Copying at the database level won't be enough: scheduled tasks are SQL Server Agent jobs that also need migrated. For more, see "How to: Migrate a Reporting Services Installation"