Change Embeded DataSource to Shared

Question

Hello,
We have migrated not only our SSRS Server to a new server but we also migrated our SQL Server that is used in about 500 Reports to a new Server. Unfortunately all these reports have been created using Embedded DataSources instead of Shared. I have created a Shared Data Source for the new SQL Server that the reports should pull from. How can I programmatically update all the Reports to use this Shared Data Source instead of the Embedded one? I have manually edited a few to ensure all works and they do. I rather not have to touch 500 reports and do this if I can avoid it.

Answer 1

Hi @Rich Vieira ，
One way is to update your data source after you migrate the report:

  USE [ReportServer]  
  GO  
      
  UPDATE [dbo].[DataSource]  
  SET [Link] = (SELECT TOP 1 [ItemID] FROM [dbo].[Catalog] where name = [dbo].[DataSource].[Name])  
  WHERE name is not null and link is null  

See more: SSRS : Bulk Update Custom Data Source

If you want to use the shared datasource to overwrite the previous embedded datasource, please refer to: Bulk update of shared datasource for SSRS reports
Best Regards,
Joy

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.