OraFAQ Forum: Server Utilities » Using SQL Loader for Migration

Home » RDBMS Server » Server Utilities » Using SQL Loader for Migration

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

Using SQL Loader for Migration [message #72974]

Mon, 05 January 2004 20:14

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

Junior Member

I am trying to use SQL Loader to migrate a .dbf database to Oracle 8i. The Oracle 8i Database has many tables related to each other by common Fields and Primary/Foriegn Keys. What procedure would you guys recommend that I use to accomplish this? Any assistance is welcome. Thanks.
Aldous.

Report message to a moderator

Re: Using SQL Loader for Migration [message #72977 is a reply to message #72974]

Tue, 06 January 2004 02:48

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

could u throw some light on the '.dbf' database?

Report message to a moderator

Re: Using SQL Loader for Migration [message #72978 is a reply to message #72977]

Tue, 06 January 2004 13:47

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

Junior Member

The .dbf file is a Foxpro 2.6 for DOS database file. I need to migrate a lot of files. Any help is appreciated. Thanks.
Aldous.

Report message to a moderator

Re: Using SQL Loader for Migration [message #72982 is a reply to message #72978]

Thu, 08 January 2004 05:02

Eric
Messages: 78
Registered: April 1999

Member

You can take a look at DataAnalyst, which can automatically migrate your data source (Foxprox in your case) to target database. We used it in our migration projects (Access --> Oracle), works great. Here is the link: http://www.agileinfosoftware.com/download/products.asp

Report message to a moderator

Previous Topic:	error in copying form one db to another
Next Topic:	sqlloader for windows

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 01 11:10:28 CDT 2024