Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Database

Status
Not open for further replies.

NaveedH

Technical User
Joined
May 11, 2010
Messages
3
Location
US
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
 
it sounds like you will need to re-write the reports using the new database structure.
 
thank you so much!

I am doing the same
 
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

 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top