Editing the ReportServer.dbo.Subscriptions table's Report_OID Field

• jbarry 87949

  Mr or Mrs. 500

  Points: 576

  More actions

  February 25, 2014 at 1:14 pm

  #284002

  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'

  updates

  sets.Report_OID = @New_Report_OID

  fromreportserver.dbo.Subscriptions s

  wheres.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.