OraFAQ Forum: Networking and Gateways

Home » RDBMS Server » Networking and Gateways » Oracle to Sql server (12c)

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

Oracle to Sql server [message #681615]

Sun, 09 August 2020 05:10

mdarifdxb20
Messages: 7
Registered: August 2020

Junior Member

i want to build connectivity between sql server and oracle 12 db , like tables from both the databases need to interact like we need to wrtie data from sql server to Oracle and from oracle to sql server. Initially i thought of using ORDS to do this. Do we have a method .

Report message to a moderator

Re: Oracle to Sql server [message #681620 is a reply to message #681615]

Sun, 09 August 2020 06:48

EdStevens
Messages: 1377
Registered: September 2013

Senior Member

If you want MSSQL to act as a client to oracle, you use MSSQL 'shared server'. If you want oracle to act as a client to mssql, you use oracle 'database link'.

Report message to a moderator

Re: Oracle to Sql server [message #681627 is a reply to message #681615]

Sun, 09 August 2020 08:33

John Watson
Messages: 9005
Registered: January 2010
Location: Global Village

Senior Member

When you say "ORDS", do you mean using REST enabled SQL? The developers I work with love it, but I do not know if it works against a SQL Server.

Report message to a moderator

Re: Oracle to Sql server [message #681635 is a reply to message #681620]

Mon, 10 August 2020 22:56

mdarifdxb20
Messages: 7
Registered: August 2020

Junior Member

I mean it will be both ways, we may have to send data from Sql server to Oracle and from Oracle to Sql server.
It will be two way commuication. For example when there is a new record created in customer master table in oracle table data from oracle table needs to be pushed to sql server table customer info. Similarly when there is a change in payment transaction at sql server table payment_info the same needs to be pushed to Oracle.

Report message to a moderator