• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

data migration

 
sanjay pandey
Greenhorn
Posts: 8
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
data migration from foxpro2.6 to oracle
 
Mark Spritzler
ranger
Sheriff
Posts: 17278
6
IntelliJ IDE Mac Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Mark Spritzler
ranger
Sheriff
Posts: 17278
6
IntelliJ IDE Mac Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 118
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Ah Mark !! Am wondering how much you know about Databases !! ''
Regards,
Praveen
 
Mark Spritzler
ranger
Sheriff
Posts: 17278
6
IntelliJ IDE Mac Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic