How to migrate a Reporting Service report from a UAT machine to a PRD machine

• onlo

  SSCertifiable

  Points: 5080

  More actions

  April 27, 2010 at 4:44 am

  #221941

  Can anybody teach me how to : migrate a SQL 2008 Reporting Service report from a UAT machine to a PRD machine.

  I expected a Reporting Service report was just a windows file and report migration was just simply file copy.

  But I couldn't find out a report's file in Windows Explorer.

  Please tell me how to do it.

  Thanks

• Dan.Humphries

  SSChampion

  Points: 12125

  More actions

  April 27, 2010 at 2:02 pm

  #1158495

  We use reporting services scripter. you can download it from here

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

  Dan

  If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.

• Perry Whittle

  SSC Guru

  Points: 234013

  More actions

  April 27, 2010 at 3:15 pm

  #1158542

  i too, use the RSS tool. Easiest way to migrate

  -----------------------------------------------------------------------------------------------------------

  "Ya can't make an omelette without breaking just a few eggs" 😉