Moving Reporting Services reports

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Analysis Server and Reporting Services (2008)

Moving Reporting Services reports

Author

Topic

jbates99
Constraint Violating Yak Guru

396 Posts

Posted - 2014-01-08 : 13:21:46

Just how much effort is needed to move an RS 2008 R2 report from one server to another? Can anyone give me some tips please?
Thanks.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-01-08 : 14:23:02

I haven't touched SSRS In a while, but can't you export it to an rdl file and then import it? You would use Report Server for that.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2014-01-09 : 05:14:09

you have different options
1. if you've direct access to report server you can export rdl from server as Tara suggested and import it to new server
2. If you want to do it programatically you can use rs utility to do it
http://technet.microsoft.com/en-us/library/ms162839.aspx
http://azuresql.codeplex.com/releases/view/115207
3. Another method is to use Reporting Services Migration Tool
http://www.microsoft.com/en-us/download/details.aspx?id=29560#overview

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources