Migration to 2004 database

[psheff]

I am moving all my data over to a new database for 2004. It is an exact replication of 2003 - Same tables, fields etc. This is accessed through an ODBC connection.

Since the tables are indentical and I require the same report sin 2004, I am wondering if there is a way to replace the source destination instead of re-creating all my reports. I have tried removing the source destination and replcaing it with the new one, but that of course removes all the fields and formula's selected.

Any ideas?

 

[Reebo99]

You should be able to alter the ODBC connection settings to point at the new database...

Reebo
UK

"Only two things are infinite, the universe and human stupidity, and I'm not sure about the former."
- Albert Einstein (1879-1955)

 

[synapsevampire]

This is dependent upon your version of Crystal, something you should include in all posts.

You havea quick solution available, change the ODBC connection to point to your bew database.

If that's not feasible for whatever reason, use the Database->Set Location in each report to change it's source.

Contact the folks who make .rpt inspector, it may handle changing multiple reports:

http://www.recrystallize.com/merchant/softwareforces/rptinspector.htm

-k

 

[SFLLC]

Yes, .rpt Inspector 2 Professional Suite for CR 8.5 & .rpt Inspector 2 Professional Suite for CR 9 (both of which should be shipping shortly) among hundreds of new features have the ability to now do batch data source / database migration and conversion.

With version 2, we have drastically expanded our connectivity support to include ODBC, OLE DB, & Native DB2/Informix/Oracle/SQL Server/Sybase both for the preview (viewer(s)) window(s) and for the batch data source / database migration and conversion wizard.

In this wizard you can specify the action(s) to take on the destination(s) including Convert, Set Location, and Verify.

Once the product starts shipping, a FREE 30-day trial will be available for download from our web site.

Software Forces
proud makers of .rpt Inspector(TM), SPL(TM) (Smart Pick Lists), SmartObjects(TM)
coming soon: .rpt Inspector 2 Professional Suite for CR8.5 & CR9.0 and .rpt Inspector 3 Enterprise Suite

http://www.softwareforces.com