OraFAQ Forum: Server Utilities » migrate data from forpro to oracle (merged)

Home » RDBMS Server » Server Utilities » migrate data from forpro to oracle (merged)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

migrate data from forpro to oracle (merged) [message #274267]

Mon, 15 October 2007 05:03

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

MarcL
Messages: 455
Registered: November 2006
Location: Connecticut, USA

Senior Member

If Foxpro is ODBC compliant, why not just do it that way ?

Report message to a moderator

migrate data from forpro to oracle [message #275519 is a reply to message #274267]

Sun, 21 October 2007 00:58

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

Michel Cadot
Messages: 68665
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

Report message to a moderator

Re: migrate data from forpro to oracle [message #275605 is a reply to message #275523]

Mon, 22 October 2007 01:09

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

Report message to a moderator

Re: migrate data from forpro to oracle [message #275612 is a reply to message #275605]

Mon, 22 October 2007 01:29

Michel Cadot
Messages: 68665
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

Report message to a moderator

Re: migrate data from forpro to oracle [message #275639 is a reply to message #275612]

Mon, 22 October 2007 03:18

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

Report message to a moderator

Re: migrate data from forpro to oracle [message #275647 is a reply to message #275639]

Mon, 22 October 2007 03:38

Michel Cadot
Messages: 68665
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

Report message to a moderator

Re: migrate data from forpro to oracle [message #275660 is a reply to message #275639]

Mon, 22 October 2007 04:28

senged
Messages: 10
Registered: October 2007
Location: asia

Junior Member

foxpro dos version

Report message to a moderator

Re: migrate data from forpro to oracle [message #275662 is a reply to message #275660]

Mon, 22 October 2007 04:33

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)

Report message to a moderator

Re: migrate data from forpro to oracle [message #275666 is a reply to message #275662]

Mon, 22 October 2007 04:39

Michel Cadot
Messages: 68665
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

Report message to a moderator

Re: migrate data from forpro to oracle [message #275676 is a reply to message #275666]

Mon, 22 October 2007 05:35

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

Michel Cadot
Messages: 68665
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

Report message to a moderator

Re: migrate data from forpro to oracle [message #275716 is a reply to message #275688]

Mon, 22 October 2007 08:45

Barbara Boehmer
Messages: 9097
Registered: November 2002
Location: California, USA

Senior Member

http://www.orafaq.com/forum/mv/msg/26365/72346/43710/

Report message to a moderator

Previous Topic:	Help about Sql loader
Next Topic:	ORA-03135: connection lost contact

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jun 26 14:02:06 CDT 2024