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]

Re: Snapshot from DB2 to Oracle

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.spammarshal l.com>

------------------------------------------------------------------------
Prakash wrote:
[color=blue]
>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
>
>[/color]

[Larry Edelstein]

Re: Snapshot from DB2 to Oracle

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

Larry Edelstein

Prakash wrote:
[color=blue]
> 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[/color]

[Daniel Morgan]

Re: Snapshot from DB2 to Oracle

Prakash wrote:
[color=blue]
>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
>
>[/color]
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/ext/certificates/oad/oad_crs.asp

http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp

damorgan@x.wash ington.edu
(replace 'x' with a 'u' to reply)

[DB2]

Re: Snapshot from DB2 to Oracle

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

venkatprakash@h otmail.com (Prakash) wrote in message news:<78b3b5e2. 0310170934.5eb6 9d22@posting.go ogle.com>...[color=blue]
> 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[/color]