| Author |
Message
|
| vivek.choudhary |
 Posted: Fri Sep 14, 2007 12:53 am Post subject: Database to database transfer |
 |
|
Newbie
Joined: 04 Jan 2007
Posts: 4
Location: India
|
Hi Gurus,
I want to know is there any middleware product is available using which we can transfer data between two hetrogenous database system.
Basically we want to maintain data integrity on the both databases residing on two diffrent type of databases.
So if there any update took place in any of the database we want reflect the same in other.
And you can also suggest if we can somehow use MQ and WBIMB for implementing this functionality.
Waiting for your expert comments.
Thanks in advance,
Viv  |
|
| Back to top |
|
 |
| Vitor |
| Posted: Fri Sep 14, 2007 1:09 am Post subject: Re: Database to database transfer |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| vivek.choudhary wrote: |
| I want to know is there any middleware product is available using which we can transfer data between two hetrogenous database system. |
I think most of the products on the market can achieve this. One way or another. At various price points.
| vivek.choudhary wrote: |
Basically we want to maintain data integrity on the both databases residing on two diffrent type of databases.
So if there any update took place in any of the database we want reflect the same in other. |
I think they all do this as well.
| vivek.choudhary wrote: |
| And you can also suggest if we can somehow use MQ and WBIMB for implementing this functionality. |
Certainly yes.
Which method / product best meets your needs? Only you can answer that. It's why POC was invented. 
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| vivek.choudhary |
| Posted: Fri Sep 14, 2007 1:18 am Post subject: |
|
|
Newbie
Joined: 04 Jan 2007
Posts: 4
Location: India
|
Thanks Vitor,
I know this is not a unique requirement that encountered for the first time but in order to reduce my area of exploring I have asked it in forum for having opnion of experts.So if possible plz provide some meaningful.
Thanks once again.... |
|
| Back to top |
|
|
| Vitor |
| Posted: Fri Sep 14, 2007 1:28 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| vivek.choudhary wrote: |
| I know this is not a unique requirement that encountered for the first time but in order to reduce my area of exploring I have asked it in forum for having opnion of experts.So if possible plz provide some meaningful. |
I thought my answer was meaningful. 
But:
Most (if not all) of the commercial middleware solutions provide the facility to transfer data from one database system to another. This facility is implemented in various way according to the architecture of the product & the vendor's strategy of product differentation. According, the transfer mechanism varies from out-of-the-box to a toolbox from which a solution can be built.
This differentiation is also reflected both in the price point at which the software is sold and in the number of components of the vendor solution that need to be purchased to acheive the desired result (you yourself quote the example of buying both WMQ & WMB). Hence purchase cost will vary.
Such a solution as you describe can certainly be constructed using WMQ & WMB, using a number of possible configurations depending on your exact requirements.
As to which of the various available solutions will best fit your needs this is a complex decision based not only on the data moving requirements but the current technology mix in use, the supported platforms and programming languages, the typical design methodolgy of the site (out-of-box favoured or disfavoured against bespoke) and of course the budget available. The ideal way to resolve product choice against these requirements is a proof of concept exercise.
Hope this is more meaningful for you.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| AkankshA |
| Posted: Fri Sep 14, 2007 3:57 am Post subject: |
|
|
Grand Master
Joined: 12 Jan 2006
Posts: 1494
Location: Singapore
|
some time ago... i heard about MultiMasterReplication somewhere
which caters to this.. but i am not sure if thats confined to oracle only...
may be google of it might give u directions...
--------------------------
I can only show the light's direction, u have to use your feet to reach |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Fri Sep 14, 2007 8:06 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
Have you looked at WebSphere II or WII?
_________________
MQ & Broker admin |
|
| Back to top |
|
|
|
|
