CODEWITHSUNDEEP
mysqldatabasepostgresqlsynchronization
shahjapan
shahjapan

Reputation: 14373

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 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.

Upvotes: 0

Views: 811

Answers (1)

Zachary Scott
Zachary Scott

Reputation: 21198

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.

Upvotes: 1

Related Questions