Migrate Foxpro DB to Oracle
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Thread: Migrate Foxpro DB to Oracle

  1. #1
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681

    Migrate Foxpro DB to Oracle

    Hi Friends,

    Anyone there have experience in migrating data from Foxpro to
    Oracle please. I tried to convert it to .csv but lots of fields
    have " & , inside in too making it erroneous in loading.

    Thanks
    Behind The Success And Failure Of A Man Is A Woman

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    and what does erroneous mean in this context? if you don't post errors how can anyone help you

  3. #3
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    well the most common error I encounter is ( well in .csv usuallly the character fields are enclosed in (") doulble quotes and separated by
    (,) comma.) when there is comma within comma and quote within quotes....it will give mismatch enclosure of quotes

    Help plssssssssss
    Behind The Success And Failure Of A Man Is A Woman

  4. #4
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,968
    Why can't you create an odbc connection to the oracle database and copy the data directly to Oracle?
    this space intentionally left blank

  5. #5
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    I know ODBC is for MSSQL only, I don't know if there is one for Foxpro, would you know dear
    Behind The Success And Failure Of A Man Is A Woman

  6. #6
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,968
    Quote Originally Posted by yxez
    I know ODBC is for MSSQL only, I don't know if there is one for Foxpro, would you know dear
    I don't know which version of Foxpro that you are running, but if you google it!!! You should find what you need.
    this space intentionally left blank

  7. #7
    Join Date
    Jul 2002
    Location
    Northampton, England
    Posts
    612
    Quote Originally Posted by yxez
    I know ODBC is for MSSQL only, I don't know if there is one for Foxpro, would you know dear
    I heart google...


    Y'know, in a few posts 'yxez', you will have advisor status, meaning you probably ought to be answering more questions than you ask... and you should probably stop asking for things that can be easily found by Google/Metalink by then too.
    Assistance is Futile...

  8. #8
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    wow i will be an advisor soon and get promoted? what benefits do i get aside from answering questions?

    By the way I dont know how to search much ...do u mean to say
    I searc the phrase "HOW TO MIGRATE FOXPRO TO ORACLE"?


    Thanks
    Behind The Success And Failure Of A Man Is A Woman

  9. #9
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    Hi I found some tips ...it says i have to migrate it to MS-Access first but I dont know to convert dbf to MS-access too?
    Behind The Success And Failure Of A Man Is A Woman

  10. #10
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    Quote Originally Posted by yxez
    what benefits do i get aside from answering questions?
    and what benefits do we get if we answer you?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width