powershell 如何将SSRS快照数据从一台服务器移动到另一台服务器?

uqjltbpv  于 2023-05-07  发布在  Shell
关注(0)|答案(1)|浏览(181)

我需要将SSRS快照数据从一个报表服务器移动到另一个报表服务器。我找到了一种使用PowerShell导出快照的方法,但我没有看到从那里导入数据的方法。
提前感谢您的帮助!

This SQL statement shows the snapshot data, but it appears that the data is being streamed into a BLOB in the Segment table.

select * from [dbo].[SnapshotData] SD
    join dbo.History H
      on h.SnapshotDataID = sd.SnapshotDataID
    join dbo.Catalog C
      on c.ItemID = h.ReportID
    join dbo.SegmentedChunk SC
      on SC.SnapshotDataId = SD.SnapshotDataID
    join dbo.ChunkSegmentMapping CSM
      on csm.ChunkId = sc.ChunkId
    join dbo.Segment S
      on s.SegmentId = csm.SegmentId
where 1=1
order by 
 c.Path 
, sd.CreatedDate DESC
fnvucqvd

fnvucqvd1#

你所拥有的就是你所需要的数据在segment.content中。
用新服务器上的reportid交换历史中的reportid。
按顺序加载:history(with the new reportid)snapshotdata(just goes without alteration)segmentedchunck(dont load the int segmentedchunkid its an identity)chunksegmentmapping(just goes)segment

相关问题