Update all Crystal Reports in the CMC to a new datasource at once?

We are setting up a completely new environment for our Cimpro database which means I must set up a new ODBC data source.  Is there a way, once I've done this, to switch all of the Crystal reports that have been previously set up in the Central Management Console to the new datasource at one time?  I have over 1200 objects that need to be updated and would really hate to do them individually!

Thanks!
cjtumlinAsked:
Who is Participating?
 
mlmccConnect With a Mentor Commented:
When the new source is ready will the old source still be available?

You could setup the ODBC to have the same name so when you switch it will use it.

There is a tool rptIspector that claims it can do it

http://www.softwareforces.com/Products/rpt-Inspector-Enterprise-Suite-for-Business-Objects-and-Crystal-Enterprise

mlmcc
0
 
cjtumlinAuthor Commented:
I'm not sure if the old database will go away immediately or not.  Has anyone out there ever used rptInspector? Have any experiences to share?
0
 
mlmccCommented:
I haven't.  I have read some good things on it and generally Ken Hamady doesn't link to tools that don't work as advertised.  I got the link originally through his site.

http://www.kenhamady.com/bookmarks.html

mlmcc
0
 
mlmccCommented:
0
 
cjtumlinAuthor Commented:
Thank you mlmcc!  I read Ken's review and I, too tend to trust his opinions.  I think I'll give it a try.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.