December 6, 2024 at 4:11 pm
Has anyone done a migration from sharepoint integrated ssrs to native? I'm not finding any specific documentation for this use case. We were able to get the reports migrated via the RS utility and ssrs_migration script provided by microsoft but the subscriptions and report history didnt come across. From the microsoft documentation it seems we're not able to just copy the databases over as integrated and native mode apparently have different schemas. Any info would be appreciated!
December 7, 2024 at 5:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
December 9, 2024 at 4:32 am
bump bump
December 18, 2024 at 10:28 pm
Haven't done a SP Integrated to Native mode migration, but I've done many Native to Native migrations. My experience has always been that if you are changing anything about the system, subscriptions have to all be recreated from scratch. I've seen scripts which will transfer subscriptions from one native mode SSRS server to another, but the ones I've tried had issues migrating between SQL versions. Best I've normally been able to do is to script out a list of the existing reports with subscriptions and then recreate them by hand.
--***********************************************************************
-- Run in the Reporting services database
--
--***********************************************************************
select c.[Name], c.[Path], s.LastRunTime, s.LastStatus
from [catalog] c, subscriptions s
where c.ItemID=s.Report_OID
order by [Path]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply