Database synchronization FoxPro to MySQL Database Linux

Discussion in 'MySQL' started by cwboaze, Dec 21, 2007.

0
  1. #1
    Hi all,

    I hope someone will have a clue of an answer for this one,
    I have a client that loves using FoxPro on his windows computer.

    Well, I have built tons of web applications for him, the newest
    one he is wanting to know if it is possible to allow
    him to update his information in FoxPro, and foxpro update
    the remote MySQL Database in which runs the web application!,

    what would be the best route in getting this accomplished?

    do you know a software which will plugin to foxpro, and allow
    to this to happen, and what is the setup for the remote
    mysql server.

    I have never had to make my Linux mysql available for synchronization
    from windows.

    Is this possible!, and if so how!, and what is the best way of
    doing it?

    Thanks so much in advance!
    CB
     
    cwboaze, Dec 21, 2007 IP
  2. Kuldeep1952

    Kuldeep1952 Active Member

    Messages:
    290
    Likes Received:
    18
    Best Answers:
    0
    Trophy Points:
    60
    #2
    There are two ways you can do this:

    1) Simple solution - Export Foxpro data as a csv file, and use phpmyadmin to import it into mysql.
    Disadvantage - Full data is exported each time.

    2) Complex solution - Post the data from within Foxpro to a script which will handle the posted
    data and import it into mysql. It will require programming both in foxpro and php, but can handle
    incremental changes.
     
    Kuldeep1952, Dec 21, 2007 IP
  3. graformix

    graformix Member

    Messages:
    92
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    41
    #3
    Hello,

    Take a look at dbsync tools at the site in my signature ;)
     
    graformix, Dec 21, 2007 IP
  4. muffieshannen

    muffieshannen Peon

    Messages:
    47
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    If the database you and he is using is MYSQL, you will just connect both to that database. Once you update your tables and as long as he is connected on the Remote Views using your tables, you can exchange data freely.

    But if he is using Local Database, advise him to use Connections where he can access on the MYSQL. Just supply the Connection String and both of you are connected on MYSQL.
     
    muffieshannen, Nov 10, 2010 IP