Firebird and Mysql

Asked

Viewed 182 times

1

I am developing a web system, I need to fetch data from a table, the data is in Firebird but I need to replicate in a mysql database every Firebird database. Case: There is an existing system using Firebird, which I cannot use, so I was wondering if it is possible to make a "Trigger" that automatically replicates in another table in another bank.

mysql database firebird trigger

1 answer

0

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

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

Desktop and web environment, handle everything with PHP.

Browser other questions tagged mysql database firebird trigger

You are not signed in. Login or sign up in order to post.