#1
  1. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2000
    Location
    Leuven, Belgium
    Posts
    39
    Rep Power
    14

    Question Sync (offline) Firebird SQL and (online) MySQL


    Hi,

    I'm no DB-wiz, rather a web-developer. But I have this technical problem. I have to make something to sync 2 databases, a Firebird SQL and a MySQL. The Firebird-db is on a application-server, the MySQL on a webserver.

    Why are we doing this? The data has to be used in a web-application, but the client doesn't want the original database (FB SQL) to be put online. They still have to be alble to work on it locally. So we duplicate a part of the data in a MySQL-db on the webserver.

    Does anyone have an idea how to sync these databases automatically? It doesn't have to be realtime. An interval of 6 or 12 hours would be fine.
    For now, I don't need a detailed sollution. A technical outline would already be great!

    Thx for the help!
  2. #2
  3. Contributing User
    Devshed Frequenter (2500 - 2999 posts)

    Join Date
    Jun 2002
    Location
    Washington, DC
    Posts
    2,692
    Rep Power
    21
    Is this all on one network / is the web server owned by the same client?
  4. #3
  5. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2000
    Location
    Leuven, Belgium
    Posts
    39
    Rep Power
    14
    Both the app-server and the web-server are from the client, but the app-server is located in the office, the web-server in a datacenter. The sync should happen through the internet-connection of the app-server.
  6. #4
  7. Contributing User
    Devshed Frequenter (2500 - 2999 posts)

    Join Date
    Jun 2002
    Location
    Washington, DC
    Posts
    2,692
    Rep Power
    21
    Well - there are a number of ways you can do it. You are going to need something/some app in the middle to create the correct queries.

    If the office server is *nix type - run a cron tab to run the middle app to grab the data from the office fb db - create the sql queries for mysql, connect to the remote server and run the queries.

IMN logo majestic logo threadwatch logo seochat tools logo