Re: Oracle 7.3 and Foxbase

I would not use Visual Foxpro for the migration. You are best off creating a delimited file and using SQL*Loader.

Why? Because Visual Foxpro will generate an INSERT INTO <TableName> COLUMNS (<ColumnList>) VALUES (<Values>) statement and a commit for every single row. This chews up the SGA memory and the performance is extremely poor. Updates seem to be even worse. Visual Foxpro is a good tool for OLTP programs, but is definitly not the way to go when it comes to large inserts or updates. Do it this way and the DBAs will not be too happy with you.

Shawn

McMalo <McMalo_at_HotMail.com> wrote in message news:ZdvK2.9865$gn1.36241_at_newscene.newscene.com...
> Use Visual foxpro . You can connect to Oracle via ODBC, create a remote
> view,
> open it, open you foxbase table (by the way, is dbase format) in another
> work area , an the issue a
>
> select <oracle-remote-view>
> append from <foxbase_table_name>
> =tableupdate(.t.,.t.)
> and presto!
>
> don't forget to set up the remote view as updatable.
>
> Gazelle wrote in message <7dct7h$588_at_news_nt.cc.ege.edu.tr>...
> >Hi All,
> >
> >We are using the database Foxbase in our applications. But now our system
 is
> >changing. We are going to start using Oracle 7.3
> >Is there any way to transfer data from Foxbase to Oracle 7.3.?
> >Please, if somebody can help me out by providing the full way out. I'll
 be
> >thankfull
> >
> >Regards
> >Melike Öztürk
> >
> >
>
>
Received on Thu Mar 25 1999 - 00:00:00 CET