How to switch database server easily?

[azhong]

We have two database servers, one for DEV, one for PROD, both have identical data tables and views.
We also have 100 crystal reports.
How can I switch the data source for all of the reports other than going into each one and using the database experts to change manually?

Thanks,
Alan.

[jasonli]

try to set PROD datasource info to report document object when you call report in program.