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!
Is this all on one network / is the web server owned by the same client?
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.
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.