Re: syncing with a MySQL DB - Mailing list pgsql-general

From Merlin Moncure
Subject Re: syncing with a MySQL DB
Date
Msg-id b42b73150810210640s18da6ec3lbefe2ecae57d88bb@mail.gmail.com
Whole thread Raw
In response to syncing with a MySQL DB  ("Brandon Metcalf" <bmetcalf@nortel.com>)
Responses Where are updates from inside transactions visible?  ("Rob Richardson" <Rob.Richardson@rad-con.com>)
Re: syncing with a MySQL DB  ("Brandon Metcalf" <bmetcalf@nortel.com>)
List pgsql-general
On Tue, Oct 21, 2008 at 9:07 AM, Brandon Metcalf <bmetcalf@nortel.com> wrote:
> I have a need to keep a PostgreSQL and MySQL table synchronized.  My
> thoughts are to use triggers on the pgsql side to manipulate the MySQL
> table when data in the pgsql table is changed.  I also plan on using
> PL/Perl to write the functions.
>
> Are there better ways to achieve this?

have you looked at dbi-link?

merlin

pgsql-general by date:

Previous
From: "Brandon Metcalf"
Date:
Subject: syncing with a MySQL DB
Next
From: "Rob Richardson"
Date:
Subject: Where are updates from inside transactions visible?