works good with destination ssrs server with url http but does not work with with https. The error shows that it looks for http. My SSRS server has a load balancer in front of it and the cert has been installed there. Can you suggest what adjustment I need to do to make rs.exe works?
github.com/Microsoft/sql-server-samples/tree/master/samples/features/reporting-services/ssrs-migration-rss Located at Github. But we've tried running this on an SSRS 2017 server to the March 2018 Power BI server, and it fails the copying with 404 error messages.
2017 is backwards compatible with 2012. You can import 2012 reports into 2017. So you can use RS.EXE, you can download from 2012 and import into 2017, if you have the reports in Visual Studio, you can just change the deployment to be 2017 and deploy the reports.
Thanks.. I completed migration by identifying the main reports using the usage query then focused on them. Used PowerShell to download reports into a local folder in my system then uploaded them to new server. But I had to go to reports and select the datasources since when I uploaded the reports the datasource connections on reports were removed.
Yes, when you upload reports, you have to reset the datasources (and potential the datasets). You can do this by managing each report, or you can do a mass update with SQL.
works good with destination ssrs server with url http but does not work with with https. The error shows that it looks for http. My SSRS server has a load balancer in front of it and the cert has been installed there. Can you suggest what adjustment I need to do to make rs.exe works?
I am trying to do this but I get invalid endpoint type
Make sure you are using the "reportserver" url.
The link to download the ssrs_migration.rss file does not work.
It appears that the article on CodePlex has been taken down. I've tried a few other links from Microsoft pages and those are broken as well.
github.com/Microsoft/sql-server-samples/tree/master/samples/features/reporting-services/ssrs-migration-rss
Located at Github. But we've tried running this on an SSRS 2017 server to the March 2018 Power BI server, and it fails the copying with 404 error messages.
Does anyone know how to move reports from SSRS 2012 to SSRS 2017?
2017 is backwards compatible with 2012.
You can import 2012 reports into 2017. So you can use RS.EXE, you can download from 2012 and import into 2017, if you have the reports in Visual Studio, you can just change the deployment to be 2017 and deploy the reports.
Thanks..
I completed migration by identifying the main reports using the usage query then focused on them. Used PowerShell to download reports into a local folder in my system then uploaded them to new server. But I had to go to reports and select the datasources since when I uploaded the reports the datasource connections on reports were removed.
Yes, when you upload reports, you have to reset the datasources (and potential the datasets). You can do this by managing each report, or you can do a mass update with SQL.