June 13th, 2003, 03:27 PM
Sync (offline) Firebird SQL and (online) MySQL
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!
June 13th, 2003, 04:33 PM
Is this all on one network / is the web server owned by the same client?
June 13th, 2003, 08:00 PM
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.
June 14th, 2003, 01:08 AM
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.