February 3, 2009 at 7:21 am
Team ,
Any body has tried setting replication between SQL SERVER 2008 and Oracle 11g.
I have tried but not getting sucess in replicating data.
If any one has done this earlier please send reply.
Thanks Saurabh
February 4, 2009 at 5:25 am
Certainly works pushing data to Oracle (haven't tried it the other way).
Just make sure that you have the Oracle client software installed and the TNSNAMES/SQLCLIENT files correctly configured prior to attempting the addition of the Oracle subscriber.
February 4, 2009 at 6:09 am
here is some note from some of the techies of micrsoft.
I put some feelers out on this as the current information is not totally clear on this.
Specifically, there is a hotfix released within Cumulative Update 3 for SQL Server 2008 that suggests support for 11g
However, the hotfix is not clear as to if this is for all interactions with 11g (subscribers and publishers) or just for publishers.
Let me poke around and ill get back to you on this.
from microsoft engineer
February 16, 2009 at 6:48 pm
i was searching around and found this thread..
we have a requirement to upgrade our oracle 9iR2 Enterprise servers running on solaris to 11g. i specifically have a large sql server 2005 enterprise server doing replication from 3 oracle servers using transactional replication. we are being held up by this not working. i had an open case with MS about this. they came out with a hotfix patch. i tried the hotfix patch on sql server 2008, 32 bit, 64 bit. even though the hotfix comments specifically indicated this issue was fixed, it wasnt...
i am going to go back to my contact sometime in the next week or so and see if they ever plan to fix this.
in know what some of the issues are. knowing that i actually uncompressed the hoffix and used a hex editor on all the components looking for one of the issues i know blocks 11g from working. there is a table (forget exactly where) that is Oracle version aware. if you select * from this table the highest version is 10... for the patch to work, this key table will have to be updated, along with some other things apparently in the bulk loader and log reader....
UPDATE.. this was on hotfix cumulative number 2. there is apparently a hotfix version 3.. i will see what that one does....
FINAL UPDATE. Applied patch 3. Using SQL Server Enterprise 2008 32 on Windows Server 2008 32 with Oracle 11g Enterprise 32 on CentOS i was able to get this to work (transaction replication Oracle 11g enterprise to SQL Server 2008 Enterprise).
I am going to assume that since 2005 is also mentioned in the fix that the 2005 patch works too.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply