replication of selected tables from oracle to sql server

Question

replication of selected tables from oracle to sql server

chewychewy

Hall of Fame

Points: 3126
More actions
May 14, 2014 at 9:41 pm

#293305

Hi All,
Need advise on this.
How can we perform replication of selected tables from oracle to sql server 2012?
Understand that in Version 2014: Oracle Publishing is deprecated. Heterogeneous replication to non-SQL Server subscribers is deprecated.
What tools can we use to easily and best acheive it now?
Is this kind of setup supported by either oracle or microsoft?
thanks in advance!

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

free_mascot One Orange Chip Points: 27168 More actions · Answer 1

SQL Server 2012 support hetrogeneous replication for Oracle Subscriber. SQL supports push subscriptions to Oracle.

Install and configure Oracle client networking software and ORACLE OLE DB on the SQL Server Distributor, so that the distributor can make connection to Oracle subscriber.

Refer following link for further details:

http://technet.microsoft.com/en-us/library/ms151738(v=sql.110).aspx

http://technet.microsoft.com/en-us/library/ms151195(v=sql.110).aspx

HTH

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

spaghettidba SSC Guru Points: 105712 More actions · Answer 2

Might be worth noting that heterogeneous replication is an Enterprise-only feature, so be prepared to spend big bucks.

-- Gianluca Sartori

chewychewy Hall of Fame Points: 3126 More actions · Answer 3

Hi All,

But understand that in Version 2014: Oracle Publishing is deprecated. Heterogeneous replication to non-SQL Server subscribers is deprecated.

So i doubt it is a good decision to use it since we know that it is going to be deprecated in sql server 2014?

Any other optiosns to share?

thanks

spaghettidba SSC Guru Points: 105712 More actions · Answer 4

Oracle GoldenGate is an option. Not cheap though.

-- Gianluca Sartori

Andy Steinke Mr or Mrs. 500 Points: 565 More actions · Answer 5

Vision Solutions' Double-Take Share is another third party process that works. Alternatively, if the source Oracle tables have some kind of "row version" (it could be a datetime field that is updated every time the row changes), you could write a process to scan for new and changed records at the source, and update / insert at the target. Preferably an application would be used, but you could use a linked server with a SQL scheduled job. I do NOT recommend this from idealist perspective...but it does work...(unfortunately I have done this all too many times)