Skip to Content

Crystal Reports - Oracle to SQL Server Migration (in batch)

Mar 07 at 09:48 PM


avatar image

We have 9K Crystal reports (multiple versions) where the underlying SQL syntax needs to change from Oracle to MS SQL Server. Any guidance on approach or utilities for swapping out the underlying SQL in a report to align with the new database. Due to the number of reports, we're hoping a batch utility may exist?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Don Williams
Mar 07 at 09:51 PM

Hi Mike,

Need more details:

Are these standalone reports, meaning are they saved locally on a hard drive?

Or are they published to BusinessObjects Enterprise or CR Server?

If they are standalone and if you have a .NET or Java developer available you could write your own app using the ReplaceConnection() API to

update them.

If you don't then there are likely third party tools out there using our SDK's that can do it in batch for you.


10 |10000 characters needed characters left characters exceeded