Categories

JavaScriptPHPHTMLCssPythonWordPressWeb developmentLinuxMySQLAndroidWindowsJavaC++ / C#LayoutReactUbuntuYiiDjangoProgramming1C-BitrixLaravelSystem administrationTelegramJSONDebianPostgreSQLIOSGoogleHtaccessWindows ServerGitMacOSGoogle ChromeCMSWooСommerceBootstrapNginxSQLUnityAPI
Make a leaderReport
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
O
onogur2014-06-03 19:56:14
Career with PL/SQL, Oracle in the factory? 2Reply
K
KTG2018-12-26 04:54:24
How to access an element of a collection through a variable? 0Reply
N
nurzhannogerbek2018-12-28 16:50:19
How to add Oracle Instant Client to Docker? 1Reply
I
iscateli2022-03-03 23:47:26
How to set columns to transpose using SQL only? 0Reply
I
iscateli2022-03-05 18:57:41
How to return query results from a function if SQL is generated dynamically? 0Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question