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.
| 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 KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
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 |
|
|
|
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 KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
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 :) |
|
|
|
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. |
|
|
|
|
|
|
How to Move a RS (2008R2) Report to 2012?