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.