December 5, 2017 at 4:24 am
Hi,
We are want to migrate SQL Reporting service from SQL Server 2008 R2 to SQL Server 2016. New Reporting server up and running, now I want to move all RDL file to a new server because we have 750 reports in total I don't want to download and upload method.
anyone, please suggest me the best way to Migrate RDL files
Thanks,
Venkata
December 5, 2017 at 5:08 am
A simple backup and restore of the ReportServer database would do it, ensure you follow this guide https://docs.microsoft.com/en-us/sql/reporting-services/install-windows/migrate-a-reporting-services-installation-native-mode or this guide https://docs.microsoft.com/en-us/sql/reporting-services/install-windows/migrate-a-reporting-services-installation-sharepoint-mode depending if your in native or sharepoint mode.
The better option would be to upgrade the solutions used originally to deploy the reports to the latest SSDT / Visual Studio code base and re-deploy, if you don't have the solutions, I would advise you download all the reports, create a solution and put it in source control somewhere for additional security.
December 5, 2017 at 6:47 am
anthony.green - Tuesday, December 5, 2017 5:08 AMA simple backup and restore of the ReportServer database would do it, ensure you follow this guide https://docs.microsoft.com/en-us/sql/reporting-services/install-windows/migrate-a-reporting-services-installation-native-mode or this guide https://docs.microsoft.com/en-us/sql/reporting-services/install-windows/migrate-a-reporting-services-installation-sharepoint-mode depending if your in native or sharepoint mode.The better option would be to upgrade the solutions used originally to deploy the reports to the latest SSDT / Visual Studio code base and re-deploy, if you don't have the solutions, I would advise you download all the reports, create a solution and put it in source control somewhere for additional security.
Hi Anthony,
thanks for your inputs, additionally i found below link.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply