• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

data migration

 
Greenhorn
Posts: 8
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
data migration from foxpro2.6 to oracle
 
ranger
Posts: 17347
11
Mac IntelliJ IDE Spring
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
Posts: 17347
11
Mac IntelliJ IDE Spring
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Ranch Hand
Posts: 118
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Ah Mark !! Am wondering how much you know about Databases !! ''
Regards,
Praveen
 
Mark Spritzler
ranger
Posts: 17347
11
Mac IntelliJ IDE Spring
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
reply
    Bookmark Topic Watch Topic
  • New Topic