Skip to Content
avatar image
Former Member

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

Hello,
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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • 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.

    Don

    Add comment
    10|10000 characters needed characters exceeded