Re: Foxpro --- Oracle

Miss Ma Jessica S Cocjin (b94327_at_cs.ait.ac.th) wrote:
: hello...
 

: i just to ask if anybody knows the following :
 

: 1. can a database in foxpro be transferred to oracle?
: if yes, how is it done?
: if yes, can the updated database be retrieve back to foxpro?

NetWare version of Oracle ship with a xBASE migration utility that reads in a xBASe file and create a Oracle load file. You can then load the file via SQL*Loader to the oracle7 database. Or you can export the xBASE file to text and write a control script to do the same thing - I like the first choice better. You can also use Q+E from Intersolv to save the xBASE file to oracle7 via a nice GUI environment.

: 2. can we integrate foxpro & oracle?

Yes - you can use the same Fox front ends to Oracle - but you need to use FoxPro Professional - it has hooks to ODBC datasources.

-- 
Tim Wong
roadgoat_at_crl.com
"No TV, and no beer, makes Homer go something something. . . "