Data Transport

[SonicChen]

i'm transporting a database in foxpro to oracle.
if (they can transport directoryly)
{ help me about it; }
else if (export from foxpro and import to oracle)
{ help me about exporing from foxpro; }
else if (read foxpro DB data file and import to oracle myself)
{ help me about the db file format; }
else
{ i have no idea @.@ }
thanks very much

way to gold shines more than gold

 

[Mike Gagnon]

SonicChen

You may start by doing a search on "Oracle" in the Keyword Search in forum184. That topic has been discussed before.

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[Mike Lewis]

SoniChen,

The example in thread1252-818989 should get you started. Although the thread relates to SQL Server, the principles apply equally to Oracle.

Alternatively, look to see if Oracle has a general-purpose import tool (something like SQL Server's DTS). Maybe someone here knows about that? Or you could ask in an Oracle forum.

Mike


Mike Lewis
Edinburgh, Scotland

My Visual Foxpro web site:

http://www.ml-consult.demon.co.uk

My Crystal Reports web site:

http://www.ml-crystal.com

 

[SonicChen]

hehe, thanks.
i have read your example before your replay.
but it's appreciated after all, and i encounter more coding program for my lack of foxpro knowledge.

way to gold shines more than gold