Can you perform a mass change of the datasource of many reports? 1

[minifelt]

I have over a hundred reports that point to one database. I need to change the database name and database location for all these reports (the new database schema that the report will be pointing to is essentially the same). Is there a way to perform a mass change of the datasource of all these 100 reports? We are starting to build a business warehouse in my company and we will be changing the data sources of reports quite a bit. It's very resource intensive to change the datasources of the reports one report at a time. Would greatly appreciate a quick and efficient solution for this task.

Thank you much.

 

[IanWaterman]

I think Rpt.inspector as advertised on this site will do the job for you. I think you can down load for free and try it out for 30 days.

Ian

 

[minifelt]

Thank you Ian. The tool works well. However, one needs to know the new database schema and map the fields accurately for it to work properly. In my case, I don't have the database schema and I'm trying to figure it out as I go along. So I guess the tool doesn't work that well. But it's a good tool. May come in handy for some other applications.