Home » RDBMS Server » Server Utilities » migrate data from forpro to oracle (merged)
migrate data from forpro to oracle (merged) [message #274267] Mon, 15 October 2007 05:03 Go to next message
senged
Messages: 10
Registered: October 2007
Location: asia
Junior Member

hi again
at first thank 4 replying me!
my quesion in the other word is:
foxpro is a dos base database which is not RDBMS but it can havd connection to other database with an interface through ODBC
windows had a property in control panel-->administative tools-->Data sources(ODBC)
i want a way to make a connection between oracle and this property of windows 4 exporting data from foxpro tables to oracle tables directly with out need 4 converting fox to text and text 2 oracle!
sincerely
a_alam


------------------------------------------------------------
hi
i want 2 export data from tables in FOXPRO to oracle tables directly

in the past I used SQL LOADER but it needs to convert data from fox to text file then using this text file as input file in SQL LOADER
i want a dirct way
thanx
a_alam

[Updated on: Tue, 16 October 2007 02:53]

Report message to a moderator

Re: migrate data [message #274330 is a reply to message #274267] Mon, 15 October 2007 10:53 Go to previous messageGo to next message
MarcL
Messages: 455
Registered: November 2006
Location: Connecticut, USA
Senior Member
If Foxpro is ODBC compliant, why not just do it that way ?
migrate data from forpro to oracle [message #275519 is a reply to message #274267] Sun, 21 October 2007 00:58 Go to previous messageGo to next message
senged
Messages: 10
Registered: October 2007
Location: asia
Junior Member

hi
i wantto migrate data from fropxo tables to oracle tables
but it need these steps:
1)converting data in foxpro tables to text file
2)using this text file as input data file
3)using sqlloader for migrating data from that input file to oracle table
i need to jump off step 1 and directly migrat edata from fox to oracle
IS THERE ANY WAY TO DOING THIS?cuz convrting fox tables to text wasting my time so much
sincerely
ana

[Updated on: Sun, 21 October 2007 00:58]

Report message to a moderator

Re: migrate data from forpro to oracle [message #275523 is a reply to message #275519] Sun, 21 October 2007 01:09 Go to previous messageGo to next message
Michel Cadot
Messages: 64098
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is useless to start a new topic for this, continue on the previous one.

You got an excellent answer from Marc, does Foxpro support ODBC?

Regards
Michel
Re: migrate data from forpro to oracle [message #275605 is a reply to message #275523] Mon, 22 October 2007 01:09 Go to previous messageGo to next message
senged
Messages: 10
Registered: October 2007
Location: asia
Junior Member

hi
that answer was not enogh and does not solve my problem!
may be I must say my problem in the other word
forpro had odbc but it is not RDBMS and all problem appear here
I found that windows in control panel->administative tools->data source ODBC ,had a possibility to add different data base in it for geting relation together and migrating data
but what is the way in oracle or sql loader to make relation between fox and oracl using this win posibility?or other way
pls help me
ana
Re: migrate data from forpro to oracle [message #275612 is a reply to message #275605] Mon, 22 October 2007 01:29 Go to previous messageGo to next message
Michel Cadot
Messages: 64098
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:

that answer was not enogh and does not solve my problem!

How could we know if you don't tell us?

Quote:

forpro had odbc

Good this was the question, you should tell us in the topic we asked you and not starting a nex topic.

By the way, your product is forpro, fropxo or foxpro?

If Foxpro is ODBC compliant then you can programmatically connect to Foxpro and Oracle and move your data.

Regards
Michel




Re: migrate data from forpro to oracle [message #275639 is a reply to message #275612] Mon, 22 October 2007 03:18 Go to previous messageGo to next message
senged
Messages: 10
Registered: October 2007
Location: asia
Junior Member

hi
but how?could u pls lead me with deail of this way?
sincerely yours
ana
Re: migrate data from forpro to oracle [message #275647 is a reply to message #275639] Mon, 22 October 2007 03:38 Go to previous messageGo to next message
Michel Cadot
Messages: 64098
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Does foxpro has a programming language? If so post your question in a foxpro forum.
If not what programming do you use?

Regards
Michel
Re: migrate data from forpro to oracle [message #275660 is a reply to message #275639] Mon, 22 October 2007 04:28 Go to previous messageGo to next message
senged
Messages: 10
Registered: October 2007
Location: asia
Junior Member

foxpro dos version
Re: migrate data from forpro to oracle [message #275662 is a reply to message #275660] Mon, 22 October 2007 04:33 Go to previous messageGo to next message
senged
Messages: 10
Registered: October 2007
Location: asia
Junior Member

foxpro is a programming language that its databse engine is in the inside of itself it 's databse structure save in the file and it is not relational dat base ( it is too old)
Re: migrate data from forpro to oracle [message #275666 is a reply to message #275662] Mon, 22 October 2007 04:39 Go to previous messageGo to next message
Michel Cadot
Messages: 64098
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So create a fowpro program that read these files, connect through ODBC to Oracle and insert the data into Oracle table.

Regards
Michel
Re: migrate data from forpro to oracle [message #275676 is a reply to message #275666] Mon, 22 October 2007 05:35 Go to previous messageGo to next message
senged
Messages: 10
Registered: October 2007
Location: asia
Junior Member

so I will say my problem again
fox pro can read my tables
and i want to read my tables in oracle
how can i migrate my foxpro table to oracle
sqlloader could do this but first i must convert my fox table to text file next migrate it by sql loader to oracle table
i want donot convert my fox table to text and directly migrate fox to oracle
can u show me the way?


sincerely yours
ana

[Updated on: Mon, 22 October 2007 05:41]

Report message to a moderator

Re: migrate data from forpro to oracle [message #275688 is a reply to message #275676] Mon, 22 October 2007 06:22 Go to previous messageGo to next message
Michel Cadot
Messages: 64098
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Michel Cadot wrote on Mon, 22 October 2007 11:39

So create a fowpro program that read these files, connect through ODBC to Oracle and insert the data into Oracle table.

Regards
Michel


You know foxpro language, I don't know it.
If you don't know how to do the previous plan, ask in a Foxpro forum.

Regards
Michel
Re: migrate data from forpro to oracle [message #275716 is a reply to message #275688] Mon, 22 October 2007 08:45 Go to previous message
Barbara Boehmer
Messages: 8620
Registered: November 2002
Location: California, USA
Senior Member
http://www.orafaq.com/forum/mv/msg/26365/72346/43710/
Previous Topic: Help about Sql loader
Next Topic: ORA-03135: connection lost contact
Goto Forum:
  


Current Time: Fri Dec 02 12:34:45 CST 2016

Total time taken to generate the page: 0.15243 seconds