Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Editing the ReportServer.dbo.Subscriptions table's Report_OID Field Expand / Collapse
Author
Message
Posted Tuesday, February 25, 2014 1:14 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Today @ 9:47 AM
Points: 14, Visits: 143
So, I have an older report that has many subscriptions and each subscription has custom parameters defined. We have to replace this report with a new version and this new version of the report has a different name (cannot just overwrite it).

I know the exact ItemID of both the old and new report (from Catalog table). It appears that ItemID from Catalog table maps to Report_OID in the Subscriptions table.

Is it ok to update the Report_OID within the ReportServer.dbo.Subscriptions table to point at a new ItemID.

For example, I would update with the following query:

declare @Old_Report_OID uniqueidentifier = 'old value'
declare @New_Report_OID uniqueidentifier = 'new value'

update s
set s.Report_OID = @New_Report_OID
from reportserver.dbo.Subscriptions s
where s.Report_OID = @Old_ReportOID

Am I making the correct assumption to batch correct the Subscriptions table?

Thanks in advance.

James

p.s. Yes, I have backups. YEs, I will backup the subscriptions table before updating.
Post #1545124
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse