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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Database change from SQL Server to Oracle

Status
Not open for further replies.

kristal9

Programmer
Feb 15, 2007
95
US
I just learned that the database used for many Crystal report (XI R2) will be changing from SQL Server to Oracle.

What is the impact of the crystal reports? do they merely need to be repointed to the new database and remapped? or will they need to be rebuilt?

Any advice is appreciated. thanks!
 
Hi,
After opening the report use the Database..Set Datasource option to redirect it to the Oracle instance and, if the field names are the same Crystal can probably remap them, if not, it may need manual remapping.



[profile]

To Paraphrase:"The Help you get is proportional to the Help you give.."
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top