OraFAQ Forum: SQL & PL/SQL » Migration of Data from Foxpro to Oracle

Home » SQL & PL/SQL » SQL & PL/SQL » Migration of Data from Foxpro to Oracle

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

Migration of Data from Foxpro to Oracle [message #9895]

Thu, 11 December 2003 21:30

Aldous Jose A. Castro
Messages: 29
Registered: September 2003

Junior Member

Hello. I am trying to migrate data from a Foxpro database to an Oracle one. Aside from SQL Loader, what other methods are there to best migrate this data? Are there any softwares designed for Oracle Migration suitable for this job? I really appreciate any help you can give. Thanks.
Aldous.

Report message to a moderator

Re: Migration of Data from Foxpro to Oracle [message #9899 is a reply to message #9895]

Fri, 12 December 2003 07:00

Eric
Messages: 78
Registered: April 1999

Member

Basically you need some tools which can connect with both side and move data between them.

You may take a look at the following tools:
1) Informatica (http://www.informatica.com)
2) DataStage (http://www.ascentialsoftware.com)
Both are super parallel, and super expensive as well.

or try to use a tool called DataAnalyst (http://www.agileinfosoftware.com), it has a module called Database Import, basically you connect to your Oracle database using the tool, invoke the wizard to import data from your FoxPro database, it is very straight-forward. We use this one in several projects and so far it works great for us, support is quite good as well.

Report message to a moderator

Re: Migration of Data from Foxpro to Oracle [message #9945 is a reply to message #9895]

Tue, 16 December 2003 19:11

Aldous Jose A. Castro
Messages: 29
Registered: September 2003

Junior Member

Basically you need some tools which can connect with both side and move data between them.
You may take a look at the following tools:
1) Informatica (http://www.informatica.com)
2) DataStage (http://www.ascentialsoftware.com)
Both are super parallel, and super expensive as well.

or try to use a tool called DataAnalyst (http://www.agileinfosoftware.com), it has a module called Database Import, basically you connect to your Oracle database using the tool, invoke the wizard to import data from your FoxPro database, it is very straight-forward. We use this one in several projects and so far it works great for us, support is quite good as well.

Report message to a moderator

Re: Migration of Data from Foxpro to Oracle [message #10753 is a reply to message #9899]

Sun, 15 February 2004 20:39

ravikumar
Messages: 17
Registered: June 1998

Junior Member

Hi,
I have the data in foxpro since last 5 years,now i want to migrate that data to oracel 7.3 which,we are using in other module.Pl.Send me the procedure to migrate that.

Thanks & Regards,
Ravi Kumar.

Report message to a moderator

Previous Topic:	what is the basic difference between IN and ExISTS operator
Next Topic:	Doubt about record groups

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 12:21:20 CDT 2024