
June 13th, 2003, 02:27 PM
|
 |
Contributing User
|
|
Join Date: Nov 2000
Location: Leuven, Belgium
Posts: 39
Time spent in forums: < 1 sec
Reputation Power: 13
|
|
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!
|