Our company is moving from SSRS 2012 to SSRS 2017. I would like to know if anyone has done a similar migration. If yes, could you please guide me through the steps?
From what I read about the migration, it looks like its a very tiring process since I will have to download each report from 2012 server and upload it into 2017 server. or use PowerShell scripting to automate the same.
If anyone knows a better way to do it, I am all ears.
Thanks
Best Answer
Here's the process I use to migrate to a new report server. This is assuming you are not already using source control and you don't have a Visual Studio solution for your reports. If you do, skip to #4. If you have the database permissions, you can use the Microsoft guide Moving the Report Server Databases.
1. Backup deployed reports
%systemroot%/system32/mstsc.exe
parentFolder=""
as a zero string to save the entire folder structure with all the reports.Command Line:
rs -s http://localhost/reportserver -i D:\Scripts\Backup_Reports.rss -e Mgmt2010 -v backupFolder="D:\Scripts\BackupReports" -v parentFolder=""
Report Backup Procedure:
2. Create a Visual Studio solution
3. Use source control with Microsoft Azure DevOps Services
4. Setup deployment configuration
Setup the target deployment settings for each report project using the Configuration Manager.
Report Project Configuration
Configuration Manager
5. Build the solution
Deploy
.