Re: Develop Triggers to Sync Databases of Different Types??

From: Steve Howard <stevedhoward_at_gmail.com>
Date: 14 Mar 2007 16:42:24 -0700
Message-ID: <1173915744.540643.44680@p15g2000hsd.googlegroups.com>

On Mar 14, 7:36 pm, "Dustin" <dustin.digm..._at_gmail.com> wrote:
> I am doing research to find out if this is possible. Does anybody
> know if it is?
>
> I need to be able to make triggers that synchronize an Oracle database
> and a Postgres database. Umm, is it possible?

Data Direct (big $$$) provides drivers which support a two phase commit across two different RDBMS'. I also heard that the JDBC spec was to be updated to allow this at some point, but I don't know if it was ever implemented.

HTH, Steve Received on Wed Mar 14 2007 - 18:42:24 CDT