Q

Connecting FoxPro database to Oracle

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


This was first published in April 2001

Dig deeper on Oracle database design and architecture

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close