Synchronization of postgres and mysql database server?

What's the best way to synchronize few tables of mysql server with postgreSQL server? Currently people are executing sc开发者_运维问答ripts, which takes much time, is there any fast solution available from which we can map the tables and columns to synchronize the db server.

You could expose the data from one and consume it with the other. Something like a web service, linked server, open data framework, ODBC driver, etc. Postgres has a nice ODBC driver that works pretty well.