Move reports from one server to another

• sunny.tjk

  SSCertifiable

  Points: 5041

  More actions

  July 31, 2013 at 7:19 am

  #280733

  I need to migrate a database off of one server to another to same SQL versions(SQL 2008 R2). There are lot of reports deployed to this server(many of them related to the other databases). So, my question is how do I move the reports related to this database? I know the folder which I'd like to move on Report Manager but I'm just not sure how to do it.

  Can someone please help?

• Tee Time

  Hall of Fame

  Points: 3745

  More actions

  August 1, 2013 at 6:50 am

  #1637762

  Have a look at this.

  http://blog.sqlauthority.com/2012/05/05/sql-server-migrate-a-sql-server-reports-from-one-server-to-another-server/

  Here is a another option that I have personally used for migrating from 2005 to 2008 R2

  http://thandor.net/article/28 -Look for the RSScripter.zip link to download.