is there any automation tool to migrate report in ssrs

• shirishjani

  SSC Veteran

  Points: 252

  More actions

  November 15, 2009 at 2:49 am

  #212662

  is there any automation tool to migrate report in ssrs

• Dave Ballantyne

  SSC-Dedicated

  Points: 33667

  More actions

  November 15, 2009 at 2:53 am

  #1079444

  Migrate from what or to what ?

  Either way, i very much doubt it.

  ---

  
  Clear Sky SQL
  My Blog[/url]

• Gift Peddie

  SSC Guru

  Points: 73570

  More actions

  November 15, 2009 at 8:18 am

  #1079463

  shirishjani (11/15/2009)

  ---

  is there any automation tool to migrate report in ssrs

  I am not aware of automation of the ReportServerDB and ReportServerTempDB migration because it is also the process to upgrade SSRS but the RDL can be scripted. Check the first link for the complete migration guide from Microsoft and the second link a thread here with two RDL scripting options.

  http://msdn.microsoft.com/en-us/library/ms143724(SQL.90).aspx

  http://www.sqlservercentral.com/Forums/Topic804696-162-1.aspx

  Kind regards,
  Gift Peddie

• gainesr

  Ten Centuries

  Points: 1088

  More actions

  November 16, 2009 at 8:47 am

  #1079712

  Check out this link

  http://www.sqldbatips.com/showarticle.asp?ID=62

  Reporting Services Scripter is a .NET Windows Forms application that enables scripting and transfer of all Microsoft SQL Server Reporting Services catalog items to aid in transferring them from one server to another