我需要将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
1条答案
按热度按时间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