Re: Conversion from Visual Foxpro 3 to Oracle 7.3

From: drew <drewb_at_dnai.com>
Date: Thu, 4 Apr 2002 04:14:41 GMT
Message-ID: <FzQq8.9361$mB3.259957@news.webusenet.com>

To migrate from Foxpro to Oracle:

I would probably export (File>Export? - it's been a long time since I last used Foxpro/dBase/Quicksilver) your data to Comma Seperated values files (1 per new oracle table), FTP the files to your server, use SQL*Loader to load into your tables.

like:

LOAD DATA
INFILE 'file1.dat'
  REPLACE INTO TABLE your_table_to_load
  FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'   (
  field_one CHAR,
  ... whatever your file looks like ...
field_two INTEGER EXTARNAL
)

On 2-Apr-2002, "Adnan Jamil" <adnanjamil59_at_hotmail.com> wrote:

> Hello everyone,
>
> I have assignment to migrate/convert Visual Foxpro 3 data to Oracle 7.3. Can
> anyone guide me, from where should I start or anyone knows any tool/utility
> that can help me.
>
> Thanks
>
> Adnan
Received on Wed Apr 03 2002 - 22:14:41 CST