Re: syncing with a MySQL DB

From: "Merlin Moncure" <mmoncure(at)gmail(dot)com>
To: "Brandon Metcalf" <bmetcalf(at)nortel(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: syncing with a MySQL DB
Date: 2008-10-21 13:40:35
Message-ID: b42b73150810210640s18da6ec3lbefe2ecae57d88bb@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Oct 21, 2008 at 9:07 AM, Brandon Metcalf <bmetcalf(at)nortel(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rob Richardson 2008-10-21 13:51:12 Where are updates from inside transactions visible?
Previous Message Jozef Sevcik 2008-10-21 13:26:05 Re: Need Tool to sync databases with 8.3.1