Skip site navigation (1) Skip section navigation (2)

Re: Oracle Streams to pgsql

From: Jim Nasby <decibel(at)decibel(dot)org>
To: Jeff Fisher <jeff(dot)ironlegs(at)gmail(dot)com>
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: Oracle Streams to pgsql
Date: 2007-01-15 03:00:42
Message-ID: 3B73B6FA-D769-435A-BC2E-82138FC82935@decibel.org (view raw or flat)
Thread:
Lists: pgsql-interfaces
On Dec 12, 2006, at 1:33 PM, Jeff Fisher wrote:
> Does anyone have any information about using Oracle streams to  
> update a
> pgsql database?  I'm trying to move all of our reporting and
> datawarehousing to a postgres database.  This needs to be updated as
> our main Oracle database is upated.  Oracle streams would be ideal.

Sorry for the late reply, but since no one else posted...

I'm not familiar with Oracle Streams off-hand, and I don't have  
access to look it up right now, so I don't know if that would work or  
not. I know that it's possible to setup replication from Oracle to  
PostgreSQL since others (OmniTI in particular) have done it.  
EnterpriseDB can also replicate between Oracle and PostgreSQL, but  
you might have to buy a copy (I don't remember the licensing on the  
replicator off-hand).
--
Jim Nasby                                            jim(at)nasby(dot)net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)



In response to

pgsql-interfaces by date

Next:From: Jim NasbyDate: 2007-01-15 03:07:23
Subject: Re: ODBC: how to change search_path in DSN?
Previous:From: Jan van der WeijdeDate: 2007-01-12 13:35:08
Subject: Re: How do I detect End-of-table or End-of-limit ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group