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
G
Grigory Skvortsov2020-10-25 17:18:42
Where can there be an error here (the procedure compiles fine)? 1Reply
N
NightFantom2014-08-02 11:32:20
How to backup Oracle DB? 2Reply
I
iscateli2022-03-17 13:27:47
How to create your own double header headers in a request? 1Reply
M
MikhailCH2022-03-26 08:14:51
SAN server DL360 G8 with Oracle 7 goes into reboot due to veeam, why? 0Reply
M
Michael2019-02-06 13:13:20
How to forbid passing empty arguments to a procedure? 2Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question