FireBird and MySQL

Question

FireBird and MySQL

Navigation

#1 by (0 votes)

1

I'm developing a web system, I need to fetch data from a table, the data is in Firebird but I need to replicate it to a mysql database with every insert made in Firebird. Case: There is an existing system using Firebird, which I can not use, so I wanted to know if it is possible to trigger a trigger that replicates automatically in another table in another database.

mysql trigger firebird

asked by anonymous 04.01.2018 / 00:10

1 answer

Lighting, Neon Unity 3D I want to make a bar with my logo and with my submenu

score 0 · Answer 1

Ideally, you should build an API that starts from the Firebird output to the data processing in the MySql database. My tip is as below:

Create a PHP environment on the Firebird server. Ex: wamp, xamp, etc ..
Generate a database connection with Firebird through IBASE, and would tell you to generate a JSON file as a SQL return of the data from that table and send it via CURL.
On your web server, create a PHP page to receive this JSON and in sequence throw that data into the MYSQL database

The desktop and web environment, handle everything with PHP.