Database

[NaveedH]

Hi,

I have Crystal Reports that were designed in 2004 and they r running fine in the production database.

Now I need to migrate these reports to a diferrent database which completely has a diferrent structure.

None of the tables match and no feilds are the same way.

Can I still migrate these reports successfully?

Naveed

 

[fisheromacse]

it sounds like you will need to re-write the reports using the new database structure.

 

[NaveedH]

thank you so much!

I am doing the same

 

[IanWaterman]

YOu can map the tables individually.

Open a new connection to new database.

Then in set datasource

Highlight table in report then highlight new table and click update.

This will then open a mapping window and you can map each field. May need to uncheck match datatypes.

Its slow and tedious but a lot quicker than building report from scratch.

Ian

 

[fisheromacse]

Ian,
Depending on the data structure, remapping the tables/fields like that could save alot of time.
For the reports that i have had to redo, the table/field structure was so radically different it was easier to start from scratch and use the old report as a visual guide of sorts.