Oracle to Informix Replication

Hi Community,

I need you help in designing a replication approach. We have 30+ Oracle
tables on a AIX Box. (Oracle 9.2). We have corresponding tables in a
Informix 9.4 environment on a Sun Box. We need to have a real time
replication of data from Oracle tables to Informix tables.

I need to design this replication approach .We would preferably like to
develop our own solution than to buy an expesive tool to do this. Hence
I need your help in identifying the best way of doing this and which
technology we should use for the same.

Thanks
Nitin

.

Relevant Pages

  • Re: select * from (select * from bob) and other easy stuff
    ... I had a friend who had just gone through an Oracle demo ... Byte, Text, Serial or Serial8 datatypes in collection types not ... It seems like Informix is going out of its way ... Maybe I can get the database re-designed to avoid the use of serials. ...
    (comp.databases.informix)
  • Re: Informix 10 vs Oracle 10g
    ... It is amazing that Oracle technology could have gone so wrong despite the amount of money they have as a company, and how they could not come up with a better engine--or why haven't they dumped the current engine and made a new one that is actually better than any other product. ... single person who uses Informix who doesn't wish that Informix and IBM were as effective at creating brand awareness for Informix as Oracle is. ... If there isn't a market for Informix, no matter how great it is, you are not going to sell Informix to anyone. ...
    (comp.databases.informix)
  • Re: select * from (select * from bob) and other easy stuff
    ... I had a friend who had just gone through an Oracle demo ... Byte, Text, Serial or Serial8 datatypes in collection types not ... It seems like Informix is going out of its way ... Maybe I can get the database re-designed to avoid the use of serials. ...
    (comp.databases.informix)
  • Re: As the markets tank... Some Benchmark Stuff to distract you
    ... Oracle I truly believe and were I to wake up one morning and feel ... When I am with IBM I don't alter ... Informix is even a product, much less that it's a database engine. ... I can remember having to say the same things about Informix even when they had market share much closer to Oracle's. ...
    (comp.databases.informix)
  • Re: Combining snapclones with DataGuard
    ... am using snapclones, how can I also use DataGuard? ... Oracle Ace Director & Instructor ... Let me provide some lost information: The OS is Windows 2003 64-Bit. ... say that array-based replication "Works best in conjunction with Data ...
    (comp.databases.oracle.server)