Solved

Moving SSRS

Posted on 2014-10-05
12
143 Views
Last Modified: 2014-10-08
I have an ERP solution that has a series of customized SSRS reports that were written by a third party. That third party is no longer available and I only have a handful of rdl files and none of the original projects. The original reports were deployed to a SQL 2008 R2 instance which has been moved to a SQL 2012 instance. Would it be possible to detach the original reports and temp reports databases and move them to the new server and attach them and expect the reports to work?
0
Comment
Question by:rwheeler23
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 6
12 Comments
 
LVL 3

Accepted Solution

by:
prequel_server earned 500 total points
ID: 40362734
1. 2008R2 rdl reports should work just fine in 2012.

2. You say you have a handful of rdls? you should be able to download ALL rds of the deployed/published reports in production from Report Manager and backup them up.

3. I never did a report server DBs move as you suggest, you can try restoring a backup instead of a detach/move first to test if it works.

4. Not all SSRS info is contained in the Report server dbs, there are some config files in the system folders that you should be aware of.
0
 

Author Comment

by:rwheeler23
ID: 40362877
How do you go into Report Manager and export the rdl's? I see where you can import them.
0
 
LVL 3

Expert Comment

by:prequel_server
ID: 40362920
Hover over a report and click on the dropdown menu that appears and choose download.
0
Resolve Critical IT Incidents Fast

If your data, services or processes become compromised, your organization can suffer damage in just minutes and how fast you communicate during a major IT incident is everything. Learn how to immediately identify incidents & best practices to resolve them quickly and effectively.

 

Author Comment

by:rwheeler23
ID: 40363438
Wow, never noticed that option. If a report contains a subreport, will it download the subreport as well?
0
 
LVL 3

Expert Comment

by:prequel_server
ID: 40363616
Do you have one with a sub report? Try it and see what happens.  I think it would depend on if the subreport(s) were reference from the VS project or to a published report on the server.
0
 

Author Comment

by:rwheeler23
ID: 40364136
These reports are for utility bills. I see on one of the reports in addition to the actual amount of the bill there is a subreport that lists monthly consumption for the prior 12 months.
0
 
LVL 3

Expert Comment

by:prequel_server
ID: 40364178
ok and? did you try recovering a copy of the reportserver dbs over to your 2012 instance?
0
 

Author Comment

by:rwheeler23
ID: 40364229
That is what I am in the process of doing right now.
0
 
LVL 3

Expert Comment

by:prequel_server
ID: 40364300
ok let me know how it goes and if you encounter any issues
0
 

Author Comment

by:rwheeler23
ID: 40369245
After bringing over the encryption keys all the reports fired right up.
0
 

Author Closing Comment

by:rwheeler23
ID: 40369246
Thanks for your help!
0
 
LVL 3

Expert Comment

by:prequel_server
ID: 40369808
Glad to here
0

Featured Post

How our DevOps Teams Maximize Uptime

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us. Read the use case whitepaper.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Data source in SSRS 2 63
Cant preview report change unless report is save first 5 31
Chrome SSRS print Functionality 1 87
New to SSRS, extremely slow running report. 8 38
Time Corrections for Reports Working with a report, we made some interesting discoveries about the time corrections/updates We are using the following Parameters: Starting Entered Date (Date) formatted as Data type: "Date/Time" Ending Entered …
A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial
Suggested Courses

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question