OraFAQ Forum: Streams & AQ » AQ between Oracle

Home » Server Options » Streams & AQ » AQ between Oracle - MS SQL Server

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

AQ between Oracle - MS SQL Server [message #266770]

Tue, 11 September 2007 10:45

panzertape
Messages: 20
Registered: August 2007

Junior Member

Hi!
I've got some questions about using AQ to transfer Data between Oracle and MS SQL Server (and vice versa).
That's the setup:
2 DBMS, 2 Applications (the same)

Oracle 9i/10g.............MS SQL Server 2000/2005
.......|...............................|............
.......|<--------- data --------->|............
.......|...............................|............
Application......................Application........

1) Is it possible to realize this scenario using AQ?
2) I'm a bit confused. AQ is part of Oracle Streams; Oracle Streams are only available in the Enterprise Edition. But some pages say, that AQ is available in the Express Edition...is that true?

perhaps you guys can help me out Embarassed

thanks in advance!!
panzertape

Report message to a moderator

Re: AQ between Oracle - MS SQL Server [message #266883 is a reply to message #266770]

Tue, 11 September 2007 22:31

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

What I know is that

Oracle Streams are only available in the Enterprise Edition.

>True.

But some pages say, that AQ is available in the Express Edition.

>true.AQ is integrated with database.

Quote:

AQ is part of Oracle Streams

Who told you that?

Report message to a moderator

Re: AQ between Oracle - MS SQL Server [message #266982 is a reply to message #266883]

Wed, 12 September 2007 03:13

panzertape
Messages: 20
Registered: August 2007

Junior Member

Hey Arju! Thanks for your clarification!

Quote:

AQ is part of Oracle Streams

Who told you that?

I've read it at wikipedia
"As of Oracle release 10.1, AQ is integrated into Oracle Streams, and is called "Oracle Streams AQ"."
This line caused some irritation Smile

As for my scenario, do you think i could realize it that way? Is this possible only with AQ?
I mean, the data has to be copied in both directions (Oracle->SQL Server, SQL Server->Oracle)...
what do you think?

Report message to a moderator

Re: AQ between Oracle - MS SQL Server [message #267000 is a reply to message #266770]

Wed, 12 September 2007 04:17

panzertape
Messages: 20
Registered: August 2007

Junior Member

As far as i have seen it could be possible to realize this scenario using AQ, Oracle Gateway and MSMQ (as Message Queue System on the MS Side)

Oracle 9i/10g.............MS SQL Server 2000/2005
.......|............Oracle................|............
.......|<---AQ--> Messaging <--MSMQ--->|............
.......|...........Gateway.............|............
Application......................Application........

But I'm not sure if the Oracle Messaging Gateway supports MSMQ.It supports IBM Websphere and TIB/Rendezvous, but what is with MSMQ??
Does somebody know that??

thanks

edit: I just realized that OracleMessagingGateway is not available in the Express edition Confused

Do you have any ideas for making a bridge between AQ and MSMQ ?? Confused

[Updated on: Wed, 12 September 2007 11:26]

Report message to a moderator

Re: AQ between Oracle - MS SQL Server [message #404904 is a reply to message #267000]

Mon, 25 May 2009 06:35

n.ghaedi
Messages: 2
Registered: May 2009
Location: UK

Junior Member

hi,
I have your problem and want to transfer Data between Oracle and MS SQL Server (and vice versa) by AQ.
if you could to do that please Confused

inform me!
thanks in advanced.

Report message to a moderator

Previous Topic:	Multimaster Replication using Stream
Next Topic:	Trying to use streams to replicate tables on same machine

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 10 20:11:51 CST 2023