?
Solved

Migrating 2 instances of SSRS to a single 2012 instance

Posted on 2016-09-29
3
Medium Priority
?
60 Views
Last Modified: 2016-09-29
We have a Report Services 2008 R2 and Report Services 2012 instance.  I need to migrate both of these instances to a fresh 2012 instance.

Part of the migration process involves backing up and restoring encryption keys, as well as backing up and restoring the ReportServer database.  How does this work if there are 2 databases to backup/restore?

I am thinking it may be easier to find a migration utility that can help me migrate reports from both instances over to the new 2012 instance.

Thank you for pointing me in the right direction.
0
Comment
Question by:JWeb Admin
[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
  • 2
3 Comments
 
LVL 16

Expert Comment

by:Megan Brooks
ID: 41822429
A lot depends on how your reports are managed. If you are using 3rd party applications, you may be able to just republish to a new server. Likewise, if you develop reports using BIDS or Visual Studio with SSDT(-BI), you can republish. SSRS 2012 BIDS/VS Report Designer will migrate to the newer schema when necessary. (You can use the SSRS 2016 designer to publish to an SSRS 2012 server but you will need to set the target server version in the report project properties, build the project, and obtain the RDL files from the appropriate "bin" subdirectory where the build output resides.)

I'll assume that your data sources contain database credentials that are encrypted; that is almost always the case. If the data sources are published as shared sources and there aren't very many of them, you can re-create the shared data sources first, possibly entering the sensitive information by hand, and then republish the reports (making sure not to overwrite existing shared sources). The same should apply to other shared resources, but I can't say that I have worked with those as much (shared datasets, report parts).

If you develop your own reports containing embedded data sources, you might be able to convert them to use shared sources before republishing to the new server.

These reports, data sets, and data source files are really just XML text files. You can download them from existing servers and upload them to a new server. You can modify them using an ordinary text editor, although an XML editor would be preferred and BIDS or Visual Studio offers specialized operations that can save you time.

In my work I have sometimes created VBScript files that can be executed using the RS utility supplied with SSRS. I used to use a utility call RS Scripter which was old and was only available as an exe the last time I looked, but which still worked the last time I tried it. I just Googled it and found plenty of hits so it looks like it is alive and well.

RS Scripter creates VBScript files and batch files that you can customize according to your needs and then execute to publish to a new server. My customizations consisted mainly of adding the password information back in before publishing, and pointing to the right servers and report folders.

I also see something called from Microsoft. I haven't tried that one but it might be worth a look.
0
 
LVL 16

Accepted Solution

by:
Megan Brooks earned 2000 total points
ID: 41822433
Oops, something ate that last link. It's Reporting Services Migration Tool.
0
 

Author Closing Comment

by:JWeb Admin
ID: 41822450
Thank you
0

Featured Post

Get proactive database performance tuning online

At Percona’s web store you can order full Percona Database Performance Audit in minutes. Find out the health of your database, and how to improve it. Pay online with a credit card. Improve your database performance now!

Question has a verified solution.

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

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how the fundamental information of how to create a table.
Suggested Courses

762 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