Crystal Report 9 slow down when we move old DB to new DB server

[Former Member]

We are using Crystal Reports 9 version, recently we move to new database server and reports data source are pointing to Old database server and old database server is no longer in the network.

Now we have issue with the performance when we call the reports from web application, it is talking long time to retrieve the simple report data(e.g. 1 min.). , if we manually update the report data source pointing to new server and the reports are pulling data very quickly.(e.g. 1 second for the same report) Is there any easy solution to bulk update all the reports datasource pointing to new server, we have 1000 reports, we can not use manual process, it will take long time and it is also issue with the future if we change the server.

Thanks for your help!

Ram

Edited by: ram vaishnapu on Aug 8, 2008 8:09 PM

Edited by: ram vaishnapu on Aug 8, 2008 8:12 PM

[former_member11696]

The 1 minute timeout is due to ODBC driver trying to connect, it's the default timeout you are seeing. There is not tool Cr has to migrate/update database connection info. You can develop your own though or search the web for a third party tool, I'm sure there are lots out there.