Re: Foxpro to Oracle migration

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 13 Sep 2005 12:28:42 -0700
Message-ID: <1126639671.235061_at_yasure>


Sebastian Millies wrote:
> Does anyone know of a tool that can migrate a
> database of VisualFoxpro *.DBF files to Oracle
> 10g directly? Should run on Windows.
>
> What I currently do is to migrate Foxpro to MySQL
> (using Alexander Eltsyn's dbf2mysql converter)
> and then use the OMWB to migrate to Oracle. This
> works fine (mostly), but involves much handiwork.
>
> Thanks for any other suggestions,
> Sebastian

Given the nature of Visual FoxPro I'd suggest you dump each table as a delimited ASCII file and then use SQL*Loader.

SQL*Loader demos can be found at www.psoug.org click on Morgan's Library
click on SQL*Loader

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Tue Sep 13 2005 - 21:28:42 CEST

Original text of this message