synchronization of postgres and mysql database server?

Question

whats the best way to synchronize few tables of mysql server with postgreSQL server, currently people are executing scripts, which takes much time, is there any fast solution available from which we can map the tables and columns to synchronize the db server.

Answer 1

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.

Answer 2

You can use a third party tool, like Columbo. This tool can Compare data across formats – Databases, MS Office files, text or XML files… so long as the data can be shown in a tabular format.