Home » RDBMS Server » Server Utilities » Using SQL Loader for Migration
Using SQL Loader for Migration [message #72974] Mon, 05 January 2004 20:14 Go to next message
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.
Re: Using SQL Loader for Migration [message #72977 is a reply to message #72974] Tue, 06 January 2004 02:48 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
could u throw some light on the '.dbf' database?
Re: Using SQL Loader for Migration [message #72978 is a reply to message #72977] Tue, 06 January 2004 13:47 Go to previous messageGo to next message
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.
Re: Using SQL Loader for Migration [message #72982 is a reply to message #72978] Thu, 08 January 2004 05:02 Go to previous message
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
Previous Topic: error in copying form one db to another
Next Topic: sqlloader for windows
Goto Forum:
  


Current Time: Tue Dec 24 19:41:06 CST 2024