aspose file tools*
The moose likes Oracle/OAS and the fly likes data migration Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Soft Skills this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "data migration" Watch "data migration" New topic
Author

data migration

sanjay pandey
Greenhorn

Joined: Aug 16, 2003
Posts: 8
data migration from foxpro2.6 to oracle
Mark Spritzler
ranger
Sheriff

Joined: Feb 05, 2001
Posts: 17260
    
    6

The two posts you made are to me identical. You should have posted it as one thread.
Here are my two cents, which in this case is actually worth much much more than that.
Get Visual Foxpro instead of Foxpro 2.6. In Visual Foxpro you will be able to create "Remote Views" which connect to Oracle threw a Connection, in this case ODBC. You can then use the Remote View as if it was a .dbf file. You will have to make the Remote View updatable, so using the wizard/view builder, is the easiest approach.
Then all you have to do is use the Remote View in a work area, and use the "APPEND FROM" command in Foxpro to append from the actual Foxpro 2.6 .dbf file.
Ok so that is the basics of how to convert from Foxpro to Oracle. Here are some more suggestions.
1. Create a .sql script that will create an exact duplicate version of all your .dbf files you want to convert. This way you can make a simple program that uses the remote views then appends from the Foxpro tables. You can run them as many times as you like.
Then if you are trying to convert into a new data model that is designed in Oracle, you can now use standard SQL, PL/SQL commands to manipulate your data into the new model.
Good Luck. I am going to close the other thread. Go Buy Foxpro 7.0 or 8.0 which ever is the latest version.
Mark


Perfect World Programming, LLC - Two Laptop Bag - Tube Organizer
How to Ask Questions the Smart Way FAQ
Mark Spritzler
ranger
Sheriff

Joined: Feb 05, 2001
Posts: 17260
    
    6

Oh, one last thing, you will not be able to get Memo fields into CLOBS, you will need to put them into Long datatype fields. Then you can convert the long into a Clob afterwards.
Mark
Praveen Zala
Ranch Hand

Joined: Jul 02, 2000
Posts: 118
Ah Mark !! Am wondering how much you know about Databases !! ''
Regards,
Praveen
Mark Spritzler
ranger
Sheriff

Joined: Feb 05, 2001
Posts: 17260
    
    6

I have lots of experience of converting Foxpro dbf files into Oracle. We have completely converted our 5 applications from Foxpro data to Oracle, and rewritten the apps in VB and Oracle Forms.
Mark
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: data migration