Change DataSources for SSRS reports using T-SQL

• PJ_SQL

  SSCertifiable

  Points: 6703

  More actions

  March 7, 2017 at 11:43 am

  #335773

  I have whole bunch of SSRS reports that are pointing to a data source.
  I want to re-direct all those reports to new data source, is it possible to do those without manually changing each report using SQL script?

• sgmunson

  SSC Guru

  Points: 110640

  More actions

  March 7, 2017 at 11:47 am

  #1932109

  Why not just test the new data source query to be sure it works and then update the SSRS data source?

  Steve (aka sgmunson) 🙂 🙂 🙂
  Rent Servers for Income (picks and shovels strategy)

• sgmunson

  SSC Guru

  Points: 110640

  More actions

  March 7, 2017 at 11:48 am

  #1932111

  Just be sure it has the exact same columns and data types..   Otherwise you're going to need to re-do those reports anyway.

  Steve (aka sgmunson) 🙂 🙂 🙂
  Rent Servers for Income (picks and shovels strategy)