Migrate *.rpt report from Oracle DBS to MS SQL DBS

[Former Member]

Hello,

I have several Crystal v2008 reports that have been developed against an Oracle 11.2 database. Changing the data source from Oracle to MS SQL v2012SP1 generates 2 errors:

---------------------------

Crystal Reports

---------------------------

Failed to retrieve data from the database.

---------------------------

OK

---------------------------

---------------------------

Crystal Reports

---------------------------

Failed to retrieve data from the database.

Details: 42S02:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'MYUSER.IT_CHANGE'. [Database Vendor Code: 208 ]

---------------------------

OK

---------------------------

The object name "MYUSER.IT_CHANGE" from Oracle is called "dbo.it_change" in MS SQL now.

What is the best practice to migrate Oracle reports to MS SQL reports using an as less effort as possible approach?

Thanks!

[abhilash_kumar · Accepted solution]

Hi Daniel,

When you set the datasource to a new location, always update each table one after the other instead of updating the 'datasource name'.

So, in this situation, you would first highlight the 'IT_CHANGE' table from the Oracle source > then highlight the 'It_Change' table from the SQL Server source and hit the 'Update' button. Repeat this for every table in the report.

-Abhilash

[Former Member · Accepted solution]

Dear Abhilash,

thank you very much! You are right. I have to update each table of the current datasource (Oracle) with the new datasource (MS SQL) within CR2008. You start here:

> Database > Set Datasource Location... then you have on top the current data source and blow you have the datasource e.g., the new MS SQL one, you want

Thank you very much!!

Daniel