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

On Mar 14, 4: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?

You need to scope the problem in more detail. When you say database, do you mean just a few tables really need to be updated? Are they on the same OS? Does it need to go both ways?

A simple hack might be to write out adds and updates to an OS file, and use OS and db features as necessary to periodically check. Oracle has a neat feature called external tables (look them up in the concepts manual) that allows you to load and unload data, and other features designed to accomodate data warehouse functions, which often involve periodic data movements. I would hope postgres allows one to read and write data from flat files.

jg

--
@home.com is bogus.
"I have at least eleventeen reasons to loathe RAID5. This form of RAID
is a wee bit like sliding down a mile long razorblade into a bucket of
salt. The only remedy is to drink until it hurts and then BAARF until
it feels better. Having said that, I suspect I've been mixing my
drinking with my thinking." - Kevin Closson