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
 SQL Server Administration (2008)
 How to Move a RS (2008R2) Report to 2012?

Author  Topic 

jbates99
Constraint Violating Yak Guru

396 Posts

Posted - 2014-08-12 : 16:31:43
I have 4 RS reports that are the Timed Subscription type that run via Agent jobs. This server is being retired so I need to migrate these reports over to an existing RS instance which is 2012.
I cannot just restore the entire ReportServer database as many 2012 reports exist.
I can't seem to find out how to move just a few reports over, then integrate them into the new instance with an Agent job etc.
Thanks for any tips.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-08-12 : 17:00:04
Can't you export the reports to an rdl file and then import them into 2012? Not sure if that path works from 2008R2 to 2012. Do you have a test environment?

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

jbates99
Constraint Violating Yak Guru

396 Posts

Posted - 2014-08-12 : 18:45:01
Thanks Tara. From Sharepoint, I exported/saved the .rdl file. Now, on the 2012 RS Server, I see the Upload tab in Reporting Services Manager. Even after I do that, how can I create an Agent job to run the report which will send the report to the subscribers? (These are scheduled, Delivery subscriptions of course)
Getting a bit closer. thanks
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-08-12 : 19:02:08
Isn't that done in Report Manager? SQL Agent isn't used to schedule reports as far as I know. It's been a while since I've used SSRS though...

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

jbates99
Constraint Violating Yak Guru

396 Posts

Posted - 2014-08-12 : 19:50:35
This report is definitely ran from the Agent as a scheduled Job - you may remember seeing all those cryptic job names 0XCBA19 ...... The published reports are accessible from the website. The agent jobs have Job Category "Report Server" and they run the reports that have subscribers.
I have scripted the old job so I'll run the script on the new server. It may just work :)
Go to Top of Page

jeffw8713
Aged Yak Warrior

819 Posts

Posted - 2014-08-14 : 13:40:04
Those agent jobs are created when you create the schedule in Report Manager for each report. Manually creating the agent jobs does not setup the correct entries in the ReportServer database to manage the subscriptions.
Go to Top of Page
   

- Advertisement -