Author |
Message
|
dinesh |
Posted: Sun Sep 08, 2002 9:03 am Post subject: data |
|
|
Newbie
Joined: 28 Aug 2002 Posts: 6
|
hai...
I would like to know can we transfer the data from DB2 to Oracle database using MQSI.
Thanks |
|
Back to top |
|
 |
kirani |
Posted: Sun Sep 08, 2002 9:40 am Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001 Posts: 3779 Location: Torrance, CA, USA
|
Dinesh,
Could you pl explain more about your requirement?
It is possible to write a message flow, which reads data from one table in DB2 and insert the same data into another table into Oracle DB. _________________ Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
Back to top |
|
 |
dinesh |
Posted: Sun Sep 08, 2002 1:35 pm Post subject: data |
|
|
Newbie
Joined: 28 Aug 2002 Posts: 6
|
Hi Kiran..
What my query is, I have to transfer the data which in DB2 to Oracle database using MQSI..Is it possible ..
Thanks |
|
Back to top |
|
 |
sgopal |
Posted: Sun Sep 08, 2002 6:13 pm Post subject: |
|
|
Acolyte
Joined: 30 Jul 2002 Posts: 63
|
Dinesh,
It is possible to transfer data from DB2 to Oracle using WMQI.. But explain your requirement in detail. Do you want to send data between two different platforms? It is just data transfer or you need to do some manipulation with the data before transfer. |
|
Back to top |
|
 |
dinesh |
Posted: Tue Sep 10, 2002 10:30 am Post subject: Data Transfer |
|
|
Newbie
Joined: 28 Aug 2002 Posts: 6
|
Hi Kiran...
I had a question...what my query is i have to transfer the data
that is from AIX-(Oracle) to AIX-(DB2) using message flow in MQSI
I have to transfer the whole data with out any modification..I have
to send data between two different platforms can you guide me
how to do..if you have any exmaple try to let me know.. |
|
Back to top |
|
 |
krchoy |
Posted: Thu Sep 12, 2002 5:04 am Post subject: |
|
|
Novice
Joined: 13 May 2002 Posts: 12
|
It sounds more like a data migration than an EAI task. Sounds more like a batch SQL job of some sort.
Sounds like a one off job - data gets exported from A to B. End of project. Why message? |
|
Back to top |
|
 |
|