SSRS Reports Migration

gvamsimba
gvamsimba used Ask the Experts™
on
Hi I need to migrate our SSRS 2014 reports to SSRS 2016 server.can anyone tell me the easiest and safest
way to do this ?

Many Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Ryan McCauleySenior Data Architect

Commented:
The easiest way to do that is definitely to do an in-place upgrade - if you can take a backup of your database and then upgrade your current servers to the new version of SSRS, it should work transparently.

If you're moving to a new server, you should restore your ReportServer database on the new server and point your SSRS application servers to it - that's what we did without any issues at all.

Microsoft has some pretty thorough documentation on upgrading and migrating SSRS that you should also check out:

https://docs.microsoft.com/en-us/sql/reporting-services/install-windows/upgrade-and-migrate-reporting-services?view=sql-server-2017

If you have more specific questions, please let us know!
gvamsimbaIT Consultant

Author

Commented:
Thank Ryan, since we are migrating to 2016 server, how do I move all the Reports in Multiple folders in my current Report Manager to  the New Report Manager ?
Senior Data Architect
Commented:
Are you upgrading your existing SSRS 2014 server or installing a new one?

If you're upgrading, everything will be persisted once you upgrade so nothing should change.

If you're installing a new server, you can still do a backup/restore of your ReportServer database to a new database server, and then run the SSRS configuration wizard, point it to that database, and let it "upgrade" the new copy of the database for you. Since all of your SSRS settings and reports are stored in the database itself, that's all you need - you shouldn't need any other files. If you have encrypted data or custom templates or themes, you may need to move those from the old reporting server to the new one manually.

If you're not sure what steps to take, here's what I'd follow (assuming you're moving to a new server and running the database and SSRS on the same location):

1. Install SQL Server on a new server, including at least Database Services and Reporting Services
2. Backup (or take an existing backup) of the "ReportServer" database on your old SSRS server
3. Restore that backup to your new database server
4. Run the SSRS configuration wizard on your new server, point it to your new database server when asked, and follow the directions

If you have questions, please let me know which steps aren't clear and  can elaborate.
Introduction to Web Design

Develop a strong foundation and understanding of web design by learning HTML, CSS, and additional tools to help you develop your own website.

gvamsimbaIT Consultant

Author

Commented:
Hi Ryan , we r upgrading from 2014 to 2016 .. my main question is how do I migrate the reports from folders from report manager in 2014 to 2016 ?
Thanks
Ryan McCauleySenior Data Architect

Commented:
I'm not sure what you mean - can you provide some details on why an upgrade wouldn't work?
Visually they look like file-folders, but everything you see is contained in the SQL Server database, from the folders, to the SSRS reports, etc.
gvamsimbaIT Consultant

Author

Commented:
Guyz, but how do I point all my reports in the SSRS solution to point to the current server and how do I deploy the reports to the new server ?

Thanks

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial