Change the Report Datasource in SQL Server

Khan Abrar Ahmed
Jun 18 2015
Code

If we deployed the reports on report manager and datasource is different then we need to point the datasource each and every report, using below script we can update the datasource on all reports.

USE ReportServer;
GO
Update DataSource set Link = (select ItemID from Catalog where type=5) , name='TestDatasource'
where name = 'DataSourceTest' and Link is NULL;
GO