RDL File Replication

• Neil Burton

  SSC-Insane

  Points: 22999

  More actions

  November 22, 2013 at 5:38 am

  #301683

  Is it possible to automatically replicate rdl files across multiple servers? I know the individual files can be manually downloaded and then uploaded in multiple locations but I'd like to know if there is a way of doing it en masse. My boss has said something about it being impossible to replicate rdl files and has tasked me to find out if this is true or not. Can anybody shed any light on this? If you need any more information please ask and I'll do my best to help.

  Thanks,

  N.

  ---

  On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
  —Charles Babbage, Passages from the Life of a Philosopher

  How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

• joe_chen_toronto

  SSC Veteran

  Points: 232

  More actions

  December 5, 2013 at 12:16 pm

  #1671285

  Write your own powershell and schedule it with the Task Scheduler:

  http://www.sqlmusings.com/2011/03/28/how-to-download-all-your-ssrs-report-definitions-rdl-files-using-powershell/