Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Data replication from DB2 to Oracle
Take a look at Praxis International's OmniCopy and OmniReplicator. They copy data among heterogeneous databases (Oracle and DB2, as well as Informix, Sybase and Microsoft SQL Server). The Praxis web site is at http://www.praxisint.com
Vittorio Turchetti wrote:
>
> We have to load an Oracle 7.3 database with data coming from a DB2
> database.
> The Oracle database will be running in a Unix or NT box, while the DB2
> resides in a IBM mainframe.
> After the first load we want to refresh periodically our Oracle data
> from the DB2 source.
> We don't want to use Oracle Transparent Gateway and are looking for a
> cheaper solution.
> Have you any advice? What might be the best solution?
>
> Many thanks in advance.
-- Joel Klebanoff Klebanoff Associates, Inc. Toronto, Ontario, Canada (416) 924-6510Received on Mon Jul 21 1997 - 00:00:00 CDT