Skip to Content
Feb 05, 2020 at 09:32 AM

Crystal Report XI: Migrate from Oracle to SQL Server

413 Views Last edit Feb 05, 2020 at 06:33 PM 2 rev

I have a report using Oracle database

. I wish to migrate all to SQL Server. I am a beginner here. To all gurus, please guide and help me patiently.

What I have tried

I have tried to go to Database expert and created the SQL Serverconnection.

I have also tried Set Datasource Location and try to update

Now how do I change all the Oracle columns to SQL Server columns?

Question 2

If I opt to create a new report with SQL Server connection. How do I refer back to the Command thingy in the oracle database report to identify the relationship of all columns? For example MEMO_NO is related to PO_NO and most of the fields are related to PO_NO. How do I find out these relationships? I tried right clicking next to the Command Column name and choose Browse Data all I get is the following. Please help.


capture.jpg (565.5 kB)
databaseexpert.jpg (74.7 kB)
thefollowing.jpg (30.0 kB)