Vivek Khera vivek
Wed Nov 29 08:43:13 PST 2006
On Nov 29, 2006, at 8:56 AM, Csaba Nagy wrote:

> possible to port the slony functions so that it could be deployed  
> on an
> oracle master replicating on a postgres slave ? It would not be
> necessary for us to fully support oracle, just the master part.

At OSCON in July, Theo Schlossnagle of OmniTI described a project  
they had migrating from an Oracle data warehouse to one using  
Postgres, and they used trigger-based replication to migrate the  
data.  I'm sure he would have details on how to build the triggers  
for oracle to generate the delta log and how to make a program that  
read that log and wrote it into postgres.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 2530 bytes
Desc: not available
Url : http://gborg.postgresql.org/pipermail/slony1-general/attachments/20061129/0e099a91/attachment-0001.bin 



More information about the Slony1-general mailing list