Import Data from PostgreSQL into MySQL for dataface

[bpiper]

I have a network monitoring application using a PostgreSQL database from which I would like to automatically export data on a regular basis and import it into mySQL for use in a dataface application. I cannot alter the netmon application to use a different database, so I'm stuck with Postgres on that one. But here's the idea of what I want to do:

1. Query the Postgresql database for certain records
2. Take the results from the query and check the mysql (dataface) database for overlapping records.
3. If any new records are found in the Postgres database, execute appropriate insert statements to add those records to the mysql db.
4. If any existing records have changed in the postgres database which already exist in the mysql database, update those accordingly.

I don't want to reinvent the wheel, but I haven't found a tool that would allow me to do this. What would be the most efficient way for me to get this done?

Thanks!!

[ADobkin]

It sounds like this tool may do exactly what you want and then some:

http://dbconvert.com/convert-mysql-to-p ... l-sync.php

It's not free, but it seems pretty inexpensive for what it does. Then again, you could probably find or write something in your language of choice (PHP, Perl, Python, etc.) to accomplish basically the same thing.

Alan