I am trying to interface with a legacy system. I am currently working with Oracle 10g and need to send a data file from the Oracle 10g database to teh Foxpro 2.6a system. My problem is the Foxpro system is expecting the data file in a Foxpro 2.6a database format. Can I convert the database coming from Oracle into a Foxpro 2.6a database?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Convert Oracle 10gb to Foxpro 2.6a dbf
- Thread starter acorbally
- Start date
The first question is...
Is this a one-time data conversion?
Or is this to be an on-going conversion requirement?
Also, are you committed to FP 2.6 or is Visual Foxpro an option?
If a one-time event, you might consider sending the Oracle data to another format such as a CSV file and then doing an Import into FP.
If this is to be an on-going conversion, then your options are more limited in FP2.6. But if VFP were an option, there are a few more options.
Once we have your feedback, we will be better informed to help you.
Good Luck,
JRB-Bldr
VisionQuest Consulting
Business Analyst & CIO Consulting Services
CIOServices@yahoo.com
Is this a one-time data conversion?
Or is this to be an on-going conversion requirement?
Also, are you committed to FP 2.6 or is Visual Foxpro an option?
If a one-time event, you might consider sending the Oracle data to another format such as a CSV file and then doing an Import into FP.
If this is to be an on-going conversion, then your options are more limited in FP2.6. But if VFP were an option, there are a few more options.
Once we have your feedback, we will be better informed to help you.
Good Luck,
JRB-Bldr
VisionQuest Consulting
Business Analyst & CIO Consulting Services
CIOServices@yahoo.com
- Thread starter
- #4
A bit more history...
I have program A which is written in FoxPro 2.6a, we are re-developing it in Oracle 10g Using Forms 9.04 The process of events which leads me to the question above is as follows.
Program A has a function that creates a FoxPro 2.6a database and it is saved on a floppy disk. The floppy is then removed and taken to another computer that has another FoxPro 2.6a program on it which we will call program B. The floppy disk is inserted into the computer and program B reads the FoxPro database from the floppy. My problem is we are only able to re-develop program A at this time. Therefor the new re-developed program needs to interface with Program B. (which is unfortunately expecting a FoxPro 2.6a database on a floppy disk.
Does that help?
I have program A which is written in FoxPro 2.6a, we are re-developing it in Oracle 10g Using Forms 9.04 The process of events which leads me to the question above is as follows.
Program A has a function that creates a FoxPro 2.6a database and it is saved on a floppy disk. The floppy is then removed and taken to another computer that has another FoxPro 2.6a program on it which we will call program B. The floppy disk is inserted into the computer and program B reads the FoxPro database from the floppy. My problem is we are only able to re-develop program A at this time. Therefor the new re-developed program needs to interface with Program B. (which is unfortunately expecting a FoxPro 2.6a database on a floppy disk.
Does that help?
So, if I understand your "history", you have two FP programs:
1. Data Sender (Program A)
2. Data Receiver (Program B)
and you want to change the Data Sender program to Oracle while leaving the Data Receiver program un-changed.
While this is most certainly not the most effective method of introducing changes, I can understand how sometimes processes are forced upon you and you just have to deal with them.
My suggestion would be to create a Program C which would "translate" the Oracle data program output into a usable FP data format. And I'd recommend developing it with Visual Foxpro if possible, if not, then with FP 2.6.
Again, adding yet a 3rd program is, most certainly, not the most effective approach to making changes, but it would enable the Data Receiver to continue to receive its expected data format and it would enable your Oracle to output data in a method which could be "translated".
Good Luck,
JRB-Bldr
VisionQuest Consulting
Business Analyst & CIO Consulting Services
CIOServices@yahoo.com
1. Data Sender (Program A)
2. Data Receiver (Program B)
and you want to change the Data Sender program to Oracle while leaving the Data Receiver program un-changed.
While this is most certainly not the most effective method of introducing changes, I can understand how sometimes processes are forced upon you and you just have to deal with them.
My suggestion would be to create a Program C which would "translate" the Oracle data program output into a usable FP data format. And I'd recommend developing it with Visual Foxpro if possible, if not, then with FP 2.6.
Again, adding yet a 3rd program is, most certainly, not the most effective approach to making changes, but it would enable the Data Receiver to continue to receive its expected data format and it would enable your Oracle to output data in a method which could be "translated".
Good Luck,
JRB-Bldr
VisionQuest Consulting
Business Analyst & CIO Consulting Services
CIOServices@yahoo.com
- Status
Similar threads
