php - Automatic update or sync a table data from Postgresql to Mysql, is it possible without excel import or replication?
one text
I have two database one is Postgresql and another is Mysql Database in different serve. I copied all the data from Postgresql to Mysql using excel import. From postgresql export all data in excel and then using phpexcel library script those excel data inserted in Mysql.
Now my issue is, in Postgresql for example table_A data is continue updating. I need those data in Mysql table_A also. I thing excel export and import is not best solution. is there any where i can automatic or sync table data postgresql to mysql?
Thanks for your feedback in advance. Have a nice day at work.
Source