Forum Discussion
Helper IVMove SSRS reports to existing PBIRS
Gday,
We have around 200 reports sitting on a 2008 R2 SSRS server. Ideally we would like to move these reports to our PBIRS running on 2012. We can't simply replace the whole ReportServer DB as there are existing PB reports on it.
Can anyone point me in the direction of some automation that might copy thode 200 reports (including folder structure) to PBIRS? We have aroung 50 data sources so if we could somehow preserve credientials that would be a bonus.
Thanks for your time.
Solved for us: I found reportsync that works well. I used the powershell libraries to copy the data source directory first. ReportSync is smart emough to match on data source *name* and thus maintains referential integrity when copying. It was temptiong to try and move everything via powershell but I could not find a way to automtically link all the reports to their newly created data sources given the UUID's were different.
ReportSync: https://github.com/ghalebbadran/reportsync
Powershell documentation: https://github.com/Microsoft/ReportingServicesTools
11 Replies
- messerjc
Advocate IV
This should do the trick - you're essentially doing a migration, copying (or backing up and restoring) the ReportServer database and then restoring it either to a new database or to a new SQL Server. Then install PBRIS, and after the install you go through the Config Manager, point it at the new database and away you go. The one thing I ran into recently was that it worked much more cleanly if I also moved over my ReportServerTempDB database. I don't know that it's necessary, but it seems to help smooth out the migration in our situtaiton.
https://docs.microsoft.com/en-us/power-bi/report-server/migrate-report-server
- cnschulz
Hi,
We can't simply replace the whole ReportServer DB as there are existing PB reports on it.
Cheers
- messerjc
Apologies! I misread your original post and didn't realize you already have the existing PBIRS running. I would take a look at something like this...
It's focused on SSRS, but I would be hopeful that it may also work on PBIRS.
- cnschulz
If I clone my SSRS reportserver db and replace the one on the PowerBi Server with this, all I am goin to end up with is the SSRS reports. All of the powerbi reports will be gone.
