Way to exchange data between MS SQL and Oracle 11g via DML queries?

K

K

Konstantin Dashkevich2014-11-22 14:26:54

Oracle

Konstantin Dashkevich, 2014-11-22 14:26:54

Way to exchange data between MS SQL and Oracle 11g via DML queries?

From DB1 MS SQL, you need to write stored procedures and use DML queries to communicate with DB2 on Oracle 11g.
Basically, data from 10 tables will be pulled from DB2 using Merge, there are about 200 tables in total, the number of daily records is ~ 1000. To give in DB2 daily ~10-50 records in 2-3 tables. We need a way to permanently link the two servers. The servers are located on different computers on the same network.
All queries must be made from DB1. DB2 cannot be changed.
Thank you in advance.

Reply

Answer the question

Answer the question

In order to leave comments, you need to log in

0 answer(s)

Similar questions

V

Vladimir Dementiev2020-07-10 18:57:33

What happens to a long running SQL query when the connection is broken? 1Reply

M

Maxim2013-11-30 21:03:36

c# mapping oracle-tables master-detail 3Reply

A

Andrey Strelkov2018-08-17 08:23:26

Which Oracle provider for Entity Framework Core is currently more reliable and production-ready? 0Reply

T

tr1ck12020-07-31 19:19:27

How, when making a java (groovy) program, to pass a parameter to plsql not as a string, but as a byte array? 1Reply

M

marselabdullin2020-08-08 00:18:53

How to upload a large csv file to a spreadsheet? 2Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question