Snapshot from DB2 to Oracle

[Prakash]

Hi

Is there anyway to transfer data from Db2 to Oracle like Oracle's
snapshot?

I am doing this already using a java program which selects from source
DB2 (v8) and inserts into destination Oracle (8.1.7). Its one to one
insert.

I am wondering is there any DB2/Oracle tools which does this like a
snapshot or similar functionality.

Thanks

V Prakash

[Kathy Benson]

See WinSQL Professional (http://www.synametrics.com/winsql)
--
------------------------------------------------------------------------
This email is certified to be Spam free by Spam Marshall

You don't pay to get spam, why pay to clean it?
Visit http://www.spammarshall.com to create an account for free
<http://www.spammarshall.com>

------------------------------------------------------------------------
Prakash wrote:

Hi

Is there anyway to transfer data from Db2 to Oracle like Oracle's
snapshot?

I am doing this already using a java program which selects from source
DB2 (v8) and inserts into destination Oracle (8.1.7). Its one to one
insert.

I am wondering is there any DB2/Oracle tools which does this like a
snapshot or similar functionality.

Thanks

V Prakash

[Larry Edelstein]

You can use IBM's Data Propagator Relational product, and you will also
need IBM Information Integrator to do the "translation" between DB2 and
Oracle.

Larry Edelstein

Prakash wrote:

Hi

Is there anyway to transfer data from Db2 to Oracle like Oracle's
snapshot?

I am doing this already using a java program which selects from source
DB2 (v8) and inserts into destination Oracle (8.1.7). Its one to one
insert.

I am wondering is there any DB2/Oracle tools which does this like a
snapshot or similar functionality.

Thanks

V Prakash

[Daniel Morgan]

Prakash wrote:

Hi

Is there anyway to transfer data from Db2 to Oracle like Oracle's
snapshot?

I am doing this already using a java program which selects from source
DB2 (v8) and inserts into destination Oracle (8.1.7). Its one to one
insert.

I am wondering is there any DB2/Oracle tools which does this like a
snapshot or similar functionality.

Thanks

V Prakash

You can use IBM's Data Propagator Relational product as Larry suggests
or contact Oracle about their
line of Transparent Gateways.

--
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
http://www.outreach.washington.edu/e...oa/aoa_crs.asp
da******@x.washington.edu
(replace 'x' with a 'u' to reply)

[DB2]

Hi there,

StarQuest has a DB2 to Oracle replication solution :
http://www.starquest.com/Productfolder/infosqdr.html

It is pretty simple to use and also includes scheduled replications.

Bob

ve***********@hotmail.com (Prakash) wrote in message news:<78**************************@posting.google. com>...

Hi

Is there anyway to transfer data from Db2 to Oracle like Oracle's
snapshot?

I am doing this already using a java program which selects from source
DB2 (v8) and inserts into destination Oracle (8.1.7). Its one to one
insert.

I am wondering is there any DB2/Oracle tools which does this like a
snapshot or similar functionality.

Thanks

V Prakash