I have lots of reports(as different projects) created using the version SSRS 2008 and the Data Source is ORACLE. All the reports are connected to one DB server. But soon DB sever is going to change. So whenever there is a change in the db server I want all the reports to be automatically connected to that new server. So I don't need to individually change the data source of all the reports manually. Please help me to find a solution to this problem.
I am new to SSRS. And I haven't used SSRS 2005. I knew about the parameters in reports. But when I saw the screen print in the link, I felt like it is completely different. So now I think it will work.
But I found another method which is so simple and you might know about it. Data source of all deployed reports can be changed in the report manager which I never knew.