It seems a silly question, but I am new in this field. Can you guide me on how can I connect my FoxPro database to Oracle? I want to design some reports in Oracle using FoxPro data. Thanks in advance.
You have two options here:
One, since the two databases are from different vendors, you can use Oracle's Heterogeneous Services and ODBC drivers to link Oracle to a FoxPro database. This option will cost you some extra money though. From there, you can create a database link to the other vendor's database.
Two, you don't connect the databases, but instead copy the data into Oracle. Use whatever FoxPro utilities you have to dump the data to a flat file (comma delimited, column delimited, etc.) and then use SQL*Loader to load the data into Oracle.
The first option costs more, but you have instantaneous access to the most up-to-date data from FoxPro. The second option is free, but you have to perform the "copy" to update the data in Oracle.
For More Information
- What do you think about this answer? E-mail us at editor@searchDatabase.com with your feedback.
- The Best Oracle Web Links: tips, tutorials, scripts, and more.
- Have an Oracle tip to offer your fellow DBA's and developers? The best tips submitted will receive a cool prize--submit your tip today!
- Ask your technical Oracle questions--or help out your peers by answering them--in our live discussion forums.
- Ask the Experts yourself: Our Oracle guru is waiting to answer your toughest questions.
This was first published in April 2001