Re: Foxpro to Oracle migration
From: Sebastian Millies <REPLACE-OBVIOUSsDOTmillies_at_idsMINUSscheer.de>
Date: Fri, 16 Sep 2005 13:14:13 +0200
Message-ID: <jfcuo6240ikr.ljtk3100ffjf$.dlg_at_40tude.net>
Date: Fri, 16 Sep 2005 13:14:13 +0200
Message-ID: <jfcuo6240ikr.ljtk3100ffjf$.dlg_at_40tude.net>
baboehme_at_hotmail.com wrote on 13 Sep 2005 13:31:46 -0700:
> You can use the FoxPro list or copy commands to dump the data to ascii
> text files, then use Oracle SQL*Loader (8i or earlier) or Oracle
> external tables (9i or later) to load them into your Oracle database,
> which would require carefully creating the new Oracle structures to
> match the old FoxPro structures. This takes a little time to set up,
> but runs quickly and is ideal for a few tables with many rows of data.
Thanks everyone for your help. I'm going with SQL*Loader now to import the raw data, and will use PL/SQL to process them into a new schema.
- Sebastian