tavz Вот что мне насоветовали, я еще сам не вникал:
There are few options, how big is your foxpro DB? I suppose it's not big?
You use build ODBC connection to the Foxpro and Oracle and transfer data using tools like MS Access or even excel.
Or you can dump out foxpro data as CSV file and load into Oracle using SQL Loader or external table.
Take a look in the following thread:
*
http://forums.oracle.com/forums/thread.jspa?messageID=1230508 Migration Foxpro to Oracle
Posted: 16.07.2004 13:22
Click to report abuse... Click to reply to this thread Reply
Hi to all,
I have Oracle database and Foxpro Database.
I want to migrate data from Foxpro to Oracle Database. any body is there who can help me to solve the problem. I have to migrate individual tables from Foxpro to Oracle Database table using some short way. I have knowledge of MS Access migration but i need to migrate throgh the script.
I am going to such procedure but I found an error :
ORA-06401: NETCMN: invalid driver designator
I am waiting for reply.
Regards and take care of yourself.
Shailesh Purani
***
riyas12
Posts: 101
Registered: 10/02/99
Re: Migration Foxpro to Oracle
Posted: 10.11.2004 13:51 in response to: shaileshpurani in response to: shaileshpurani
Click to report abuse... Click to reply to this thread Reply
Hi,
There is tool provides by Oracle work bench hopes utitling that tools you will be able to get it done the migrations.
Thanks
Riyas
Senior Oracle Applications Technological Consultant DBA
riyasnit@hotmail.com
Kuwait
Barry McGillin
Posts: 1,105
Registered: 03/12/01
Re: Migration Foxpro to Oracle
Posted: 28.01.2005 14:09 in response to: riyas12 in response to: riyas12
Click to report abuse... Click to reply to this thread Reply
You've a couple of options,
1. Export the foxpro tables to csv and use SQL loader
2. Move the foxpro tables to Access and use the OMWB
Is there a foxpro application here too?
Pranav Garg
Posts: 81
Registered: 12/22/05
Re: Migration Foxpro to Oracle
Posted: 09.03.2006 9:52 in response to: Barry McGillin in response to: Barry McGillin
Click to report abuse... Click to reply to this thread Reply
hi Baary,
can you let me know how can i migrate my ASP.NET web application which is using SQL Server 2k to Oracle 9i (I need to just find the SQL Server DB queries which are incompatible on oracle) ?
I thought of using AMA provided by oracle but it seems i have to have Oracle Jdeveloper. Is there any other way out to list the incompatibilites in DB queries ?
I have already migrated by DB from SQL Server to Oracle using OMWB. No issues with that. just the application remains.
Guest
Re: Migration Foxpro to Oracle
Posted: 09.03.2006 11:14 in response to: Pranav Garg in response to: Pranav Garg
Click to report abuse... Click to reply to this thread Reply
AMA is an extension of JDeveloper, hence that is why JDeveloper is required. However it is used for assessment purposes only.
With an ASP.NET application you first have to determine how you are communicating with SQL Server? OLEDB or ODP.NET? You would then setup the equivalent driver from Oracle. It is a manual process to do this migration.
Donal
Pranav Garg
Posts: 81
Registered: 12/22/05
Re: Migration Foxpro to Oracle
Posted: 09.03.2006 13:42 in response to: Guest in response to: Guest
Click to report abuse... Click to reply to this thread Reply
Hi Donal,
I am connecting my ASP.NET through ADO to connect to SQL Server.
Provider is SQLOLEDB.
Should i download JDeveloper 9.2.0.5 along with AMA and then open ASP.NET pages in JDeveloper one by one??
or doing the application pages manually(using the Oracle Documentation)?
Guest
Re: Migration Foxpro to Oracle
Posted: 09.03.2006 15:26 in response to: Pranav Garg in response to: Pranav Garg
Click to report abuse... Click to reply to this thread Reply
Did you review the tutorials on the AMA pages on OTN, this should explain how to use it best. You should be able to get it up and running very quickly and do an initial analysis to determine how useful it would be for your situation.
Donal
Pranav Garg
Posts: 81
Registered: 12/22/05
Re: Migration Foxpro to Oracle
Posted: 09.03.2006 16:06 in response to: Guest in response to: Guest
Click to report abuse... Click to reply to this thread Reply
Hi Donal,
I did a mistake by downloading the latest version of Oracle JDeveloper and copying the ama.jar file in its respective folder only to realise the tutorial available on OTN is not the same... I mean GUI was different.
Then after 4 hours realised I downloaded the wrong version of Oracle Jdeveloper it should have been 9.2.0.5 and then it worked fine.
Now I would be doing the analysis. Would be reaching you if in case i face any issues.
If you have any points for me to help me in the Application migration please do let me know.
Thanks for the help.
Pranav
Guest
Re: Migration Foxpro to Oracle
Posted: 09.03.2006 17:16 in response to: Pranav Garg in response to: Pranav Garg
Click to report abuse... Click to reply to this thread Reply
Pranav,
We hope to provide an updated version for JDeveloper 10.1.3 in the coming months
Donal
Pranav Garg
Posts: 81
Registered: 12/22/05
Re: Migration Foxpro to Oracle
Posted: 09.03.2006 19:25 in response to: Guest in response to: Guest
Click to report abuse... Click to reply to this thread Reply
Hi Donal,
Thanks for taking it as an input. Now coming to my findings:
I generated the report using AMA and found it annotates comments on the line wherever it finds a select command in the code pages.
like it found Convert function being used of SS and it generate Oracle Reserved word but the same thing it also did for another normal query which works both in Oracle and SS.
Is AMA only build to highlight all the DB queries and one has to manually migrate the code for it following the whitepaper published by Oracle on "Migrating Applications from SQL Server to Oracle"? please correct me if i am wrong.
Message was edited by:Pranav Garg
user475408
Guest
Re: Migration Foxpro to Oracle
Posted: 09.03.2006 19:39 in response to: Pranav Garg in response to: Pranav Garg
Click to report abuse... Click to reply to this thread Reply
Yes, you must make the changes manually.
The reason we put in the comments, is that we use this a our link to be able to navigate from one to the other, and also to allow you to change "state"; so as you fix issues manually, you can record your progress. When completed you can remove these comments.
Donal
Pages: 1
Back to Thread List